Hi, I ‘ve got a case where i get two flatfiles. one with head records and one with detail records. I want to merge them together to one file and sort them before i send them to biztalk for mapping. I will illustrate the problem as follows:
Head file:
3333 L46
4444 L46
Detail file:
3333 L47
4444 L47
4444 L47
result file:
3333 L46
3333 L47
4444 L46
4444 L47
4444 L47
Where the L46 refers to Head record, L47 refers to Detail record. And the numbers are unique and are used to bind each head record with its detail records.
Any help on that PLZZZ?