Hi,
I have to create a job in which i have to extract data from three different tables and create a seq file. These files having six columns each and out which 2 columns are common. Now depending on the these 2 key columns i have to create a files having column of all three files.
Like
File1
01,A,19.0.10.11
02,B,10,20.0.05
File2
01,A,CC,BB,08,07
02,B,NN,AC,09,01
file3
01,A,11,00,55,of
02,B,33,44,00,OK
Now in Output File I want
01,A,19.0.10.11,,CC,BB,08,07,,11,00,55,of
02,B,10,20.0.05,,NN,AC,09,01,,33,44,00,OK
Please help
Thanks
How to join 3 files Lateraly
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If they're tables, as you say, why not simply join them using SQL? If they're not, load two into hashed files, and do standard lookups in a Transformer stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.