How to join 3 files Lateraly
Posted: Tue Jan 17, 2006 1:55 am
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
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