Biztalk: Map fields from two repeating record to single repeating record into flat file. RRS feed

  • Question

  • Hello All,

    I have a scenario where i am mapping my response from xml to a flat file. I have two repeating records and i want to map them to a single record in flat file.

    These both records are looping. i am not able to map them properly. Please see screenshot of mapping. I have used looping functoid. 

    At the destination as links indicate i am mapping few fields from 1st record and few from 2nd record.

    My output is as below

    I am expecting  output to be inline. as below :

    These records are being separated. I want to consolidate it. Please Help. I am stuck.

    I can accept the solution in the functoid or custom xslt too

    Thanks in advance.

    • Edited by Imenrique Monday, February 29, 2016 1:19 PM
    Monday, February 29, 2016 12:40 PM

All replies

  • Anybody has any comment/ Suggestions ? Please help
    Tuesday, March 1, 2016 7:58 AM
  • Cant do in a default mapper as is.

    Do the map in custom xslt.

    Regards <br/> When you see answers and helpful posts,<br/> please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Tuesday, March 1, 2016 12:01 PM
  • Do you know how to achieve it?
    Tuesday, March 1, 2016 12:33 PM