Hi,
I am bringing in 4 sequential files and performing a funnel. An example is shown below of one person with three rows:
ID NAME Stat Code Stat Code Description
17137 TOM 05 RECEIVED
17138 TOM 04 ADD'L
17139 TOM 08 PENDING
The files (combined) are 125 rows. I bring this into the transformer stage, where I want to extract all NAMES with a 04 stat code into the next stage.
*If the row doesn't have a 04 code or multiple rows without a 04 code, they will just pass into the next stage*
I tried a constraint but I cannot get it to work. Any guidance would be greatly appreciated.
Thanks
Trying to extract row with certain criteria
Moderators: chulett, rschirm, roy
Transformer stage is an option for this scenario and it should work with your constraint. I suspect the format of the input values coming for 'STAT CODE' is not correctly compared.
- Can you can check the actual values just right before the Transformer stage? You may be storing in Integer but comparison is done with '04' etc
- Are you using 'Otherwise' feature for the second output but it shows as the first link on the Output tab?
- Can you can check the actual values just right before the Transformer stage? You may be storing in Integer but comparison is done with '04' etc
- Are you using 'Otherwise' feature for the second output but it shows as the first link on the Output tab?