Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Mapping flatfile with multiple repeating nodes
- This topic has 0 replies, 1 voice, and was last updated 9 years, 5 months ago by
community-content.
-
AuthorPosts
-
-
June 24, 2010 at 1:39 AM #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 flatfilefrom 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><DrawingInfo DrwingNo=”CA100053“ /><DrawingInfo DrwingNo=”CQ00021S“ /></Drawing><MQSInfo MQSID=”CQ00021S“ /><MQSInfo MQSID=”CA100053“ /></MQS><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
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.