Sort/Merge not giving me the Right result.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 23, 2003 4:35 pm

Have you considered the Merge stage to read the two files, then running the result through a sort?

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

Optico · Post by **Optico** » Wed Sep 24, 2003 2:11 am

Or if you don't want to use a merge stage, you can read the two sequential files throug two 'empty' transformer stages into a hashfile using Member_Num and Member_Type as keys.

Then use the hash-file as input to a sort-stage sorting on 'Member_Num asc, Member_Type asc.' and pass the outlink to your sequential outputfile.

Et voila! Everything's fine.

B. Sorensen,
Optico IT ApS