Mapping flatfile with multiple repeating nodes

Home Page Forums BizTalk 2004 – BizTalk 2010 Mapping flatfile with multiple repeating nodes

Viewing 0 reply threads
  • Author
    Posts
    • #25051

      Hi

      I am facing a problem in mapping the repeating multiple nodes, and here is the sample flatfile

      BOMSTART            ————-  TAG in flatfile
      2;;34571;1;
      2;;34572;1;
      2;;33111;1;
      2;;33106;6;
      2;;33110;5;
      BOMEND             ————-  TAG in flatfile
      DWGSTART          ————-  TAG in flatfile
      CA100053
      CQ00021S
      DWGEND      ————-  TAG in flatfile
      MQS               ————-  TAG in flatfile
      CQ00021S
      CA100053
      CONSTART  ————-  TAG in flatfile
      F4;;
      F3;;
      F1;;
      F2;;
      CONEND    ————-  TAG in flatfile

       

      from this i need to create XMl file, i can change the structure of the xml file

      this is the required output

      <Configutaion>

        <ConfigInfo Child_ArticleNo=”34571 Conn_position=” Quantity=”1 />
        <ConfigInfo Child_ArticleNo=”34572 Conn_position=” Quantity=”1 />
        <ConfigInfo Child_ArticleNo=”33111 Conn_position=” Quantity=”1 />
        <ConfigInfo Child_ArticleNo=”33106 Conn_position=” Quantity=”6 />
        <ConfigInfo Child_ArticleNo=”33110 Conn_position=” Quantity=”5 />
        </Configutaion>
      <Drawing>
        <DrawingInfo DrwingNo=”CA100053 />
        <DrawingInfo DrwingNo=”CQ00021S />
        </Drawing>
      <MQS>
        <MQSInfo MQSID=”CQ00021S />
        <MQSInfo MQSID=”CA100053 />
        </MQS>
      <COnnections>
        <Conn_Info Connections-field1=”F4 Connections_Field2=” />
        <Conn_Info Connections_field1=”F3 Connections_Field2=” />
        <Conn_Info Connections_field1=”F1 Connections_Field2=” />
        <Conn_Info Connections_field1=”F2 Connections_Field2=” />
        </COnnections>

       

      I am generating output in this form

       

      <Configutaion>

      <ConfigInfo Child_ArticleNo=”34571” Conn_position=”” Quantity=”1” />

      <ConfigInfo Child_ArticleNo=”34572” Conn_position=”” Quantity=”1” />

      <ConfigInfo Child_ArticleNo=”33111” Conn_position=”” Quantity=”1” />

      <ConfigInfo Child_ArticleNo=”33106” Conn_position=”” Quantity=”6” />

      <ConfigInfo Child_ArticleNo=”33110” Conn_position=”” Quantity=”5” />

      </Configutaion>

      <Drawing>

      <DrawingInfo DrwingNo=”CA100053” />

      <DrawingInfo DrwingNo=”CQ00021S” />

      <DrawingInfo DrwingNo=”DWGEND” />

      <DrawingInfo DrwingNo=”MQS” />

      </Drawing>

      <MQS />

      <Connections>

      <Conn_Info Conn_field1=”F4” Conn_Field2=”” />

      <Conn_Info Conn_field1=”F3” Conn_Field2=”” />

      <Conn_Info Conn_field1=”F1” Conn_Field2=”” />

      <Conn_Info Conn_field1=”F2” Conn_Field2=”” />

      </Connections>

      I feel the problem lies in

      as there two repeating records with same delimiter type( i.e. DWGINFO and MQS Info) , so Biz talk is not able to identify the record fields from Flat file as both child delimiter type are same.

      Please let me know the solution

      Regards,

      Sree

       

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