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
Sort/Merge not giving me the Right result.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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