DSXchange

Thanks. I tried it but didnt work, i am getting random info, sometimes it shows table 1 values, other times it shows table 2 values.

Hello, I have two flat files with this format. file 1 id|desc|value| 1|test1|123 2|test|256 3|test2|951 file 2 id|desc|value| 1|test1|999 4|test|256 6|test2|951 I join these 2 files in one. Where ID is the same i put them together in one line. I need to know how can i preserve the value for field &q...