Hello,
I followed the steps in this post:
https://lavastorm.zendesk.com/hc/en-us/articles/115001973269
but the logic doesn't seem to be working.
I created 5 outputs in the script section of the transform. I then created 4 additional Outputs (out2, out3, out4, out5) on the Define tab of the Transform in the Output section.
The logic is only working for output 1 and output 2. Outputs 3,4,5 are just passing all rows without the where conditions being applied.
My code in the script section is below and is also included in the attached jpg along with the row counts. Thanks, Rob
output 1
{
emit *
where New_Effective_Date <= date("2010-12-31","YYYY-MM-DD")
}
output 2
{
emit *
where New_Effective_Date >= date("2011-01-01","YYYY-MM-DD") and New_Effective_Date <= date("2012-12-31","YYYY-MM-DD")
}
output 3
{
emit *
New_Effective_Date >= date("2013-01-01","YYYY-MM-DD") and New_Effective_Date <= date("2014-12-31","YYYY-MM-DD")
}
output 4
{
emit *
New_Effective_Date >= date("2015-01-01","YYYY-MM-DD") and New_Effective_Date <= date("2015-11-30","YYYY-MM-DD")
}
output 5
{
emit *
New_Effective_Date >= date("2015-12-31","YYYY-MM-DD")
}