Join Files which is not having key column

rakesh.nc · Post by **rakesh.nc** » Tue Feb 12, 2008 2:08 am

hi all,

I need to join two files, file1 contain col1 and file2 contain col2, i need an output in such a way that the output file should contain col1 | col2 seperately but in a one file.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 12, 2008 2:46 am

Use Column Generator stages to create a sequential key column on each input. Feed those into a Join stage. Direct the output of that into a two-column text file.

AmeyJoshi14 · Post by **AmeyJoshi14** » Tue Feb 12, 2008 2:46 am

You can use dummy column to join the two files.....
Add this column in both the file..say the name of the column is colX with value as '1'. Us join stage which will join the records based on this dummy column..

priyadarshikunal · Post by **priyadarshikunal** » Wed Feb 13, 2008 2:23 am

AmeyJoshi14 wrote: You can use dummy column to join the two files.....
Add this column in both the file..say the name of the column is colX with value as '1'. Us join stage which will join the records based on this dummy column..

dummy column may lead to cross product

its better to use Ray's suggestion if number of records are more than 1
.

or pass the row number from transformer and join on row number

Regards,