Help In merging the Files

e1994264 · Post by **e1994264** » Mon Sep 19, 2011 12:04 pm

Hi,
I got 2 ouput files with different stuctures. I need to append in to one file . and sort it based on COL2 and COL1 Please let me know:

Example:
File 1:
P001,101, US
P001,102, MI

File2:
P002,101, XYZ,234354432,loc,12
P002, 102, XYZ,43543,loc,13

I think it should be possible by unix scripting. If how it is

qt_ky · Post by **qt_ky** » Mon Sep 19, 2011 1:34 pm

It could be done in DataStage also.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 19, 2011 3:40 pm

Do you know what commands you might use in such a script, or are you relying upon DSXchange to fill a gap in your knowledge of operating system commands?

This problem can be solved with a single command pipeline - you don't even need a script!