Combine Records Stage

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
kpsita
Participant
Posts: 99
Joined: Tue Jul 21, 2009 11:43 pm

Combine Records Stage

Post by kpsita »

Hi ,

I have a question, I am using Combine record stage to combine my records. I am loading these records to a dataset.
Example from my source :
Key Field1
1 AA
1 AAA
1 AAAA

after using combine records my out in dataset looks like [(1 AA) (1 AAA) (1 AAAA).

Now I have to use this dataset as a source for my another job with a condition if Key=1 then field1. So how can I extract records from the dataset because the combine field values are of different lengths.
Can anyone please help. Any other approach other than combine records is also fine.

Thanks,
KPSITA
mjmtabor
Participant
Posts: 7
Joined: Wed Feb 28, 2007 8:03 am

Post by mjmtabor »

Did you ever come up with a solution to this problem? I have the same issue where I have two keys and if I get a match I want to move the field. Thanks Mike
Post Reply