Merge 2 files

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Merge 2 files

Post by vinaymanchinila »

Hi ,
I am using the merge stage with Compelte Set option, it works fine but a issue, like I have 2 columns in file1 and 2 columns in file2.
The output is like

Col1 col2 Col11 col22
01 01
02 02
011 011
022 022

Any way to merge 2 files with same columns?.
I did try the link collector , it gives an error because shockingly my flat file columns dont populate on the output end!
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Did you rename the first file's column name before adding second?
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Post by vinaymanchinila »

Hey The issue was resolved, I was not giving the symetric metadata.
Thanks for the idea though.
Post Reply