Merging and sorting records in two flatfiles!

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Merging and sorting records in two flatfiles!

Viewing 0 reply threads
  • Author
    Posts
    • #18471

      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? 

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.