Trying to extract row with certain criteria

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ScottDun
Participant
Posts: 61
Joined: Thu Dec 10, 2015 9:51 am

Trying to extract row with certain criteria

Post by ScottDun »

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
SCOTTDun
mouthou
Participant
Posts: 208
Joined: Sun Jul 04, 2004 11:57 pm

Post by mouthou »

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?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Scott, what was your workaround? If you want to pursue this, I'd be curious what exactly you tried constraint-wise and what did not work about it...
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply