Which is the best way to create several FF files from one xml file

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Which is the best way to create several FF files from one xml file

Viewing 1 reply thread
  • Author
    Posts
    • #18313
      I have one xml file and I want create from there one or more FlatFile file(s) 
      depending of one xml file child field element. Which is the best way to do 
      that?
      I know that there is possibilities to do that, but I can't find it. 
      
      e.g I have source XML file as below 
      
      - <ns0:Order xmlns:ns0="http://Testing.Schema1">
      - <PO_Receive>
        <PO>PO124BBB</PO> 
        <LineSum>60</LineSum> 
        <Amount>40</Amount> 
        <POID>1234</POID> 
        </PO_Receive>
      - <PO_Receive>
        <PO>PO126DDD</PO> 
        <LineSum>80</LineSum> 
        <Amount>30</Amount> 
        <POID>123</POID> 
        </PO_Receive>
      - <PO_Receive>
        <PO>PO125CCC</PO> 
        <LineSum>70</LineSum> 
        <Amount>50</Amount> 
        <POID>121</POID> 
        </PO_Receive>
      - <PO_Receive>
        <PO>PO123AAA</PO> 
        <LineSum>50</LineSum> 
        <Amount>10</Amount> 
        <POID>123</POID> 
        </PO_Receive>
        </ns0:Order>
      
      and I want to have two different FlatFiles target as below
      
      File 1
      
      PO126DDD;80;30;123
      PO123AAA;50;10;123
      
      File 2
      
      PO124BBB;60;40;1234
      PO125CCC;70;50;121
      
      This is quite novice question, but I haven't use BizTalk at long time and I 
      don't remember how to do that. I'm so grateful if someone could help me.
      
      Thanks in advance,
      Elmo
    • #18323

      I believe I've posted an answer to your question on the newsgroups, so make sure you look there (don't have it open now, so can't paste it in)

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