Read Multiple Nested loop in database

[Rajender]

Hi Community

I have a multiple nested loop xml. Read XML and load data into table. Below is required XML. 

I have enterprise version 7.1 of Talend Integration tool.  I went through several post on community. 

I tried to build mapping based on following link. Getting error while merging  <BLine> and <Acatch> into a single loop using NestedContext -> simpleLoop feature as suggested i below link. Both <BLine> and <Acatch> loop are not visible in final output. Below is error Received. 

My target is to load Clinecd, BLine, Actach, Line, Route and B-King data into separate tables.  

I am newbie to Talend.

Please suggest  on map or any other approach .  Thanks in Advance.

https://community.talend.com/t5/Design-and-Development/How-to-process-xml-message-with-multiple-loop...

<Message>
<B-king>(1-n)
<Sourceid>11111</Sourceid>
<TargetID/>
<BoNumber>0017650</BoNumber>
<BStatus>1</BStatus>
<CAStatus>0</CAStatus>
<BLine>(0-n)
<Sourceid>22222</Sourceid>
<TargetID/>
<ModelType>Cars</ModelType>
<ModelName>i10</ModelName>
<PrimaryCode>3</PrimaryCode>
<SecondaryCode>9</SecondaryCode>
<Quantity>1</Quantity>
<Clinecd>
<blineId> abc</blineId>
<blineno>cde</blineno>
</Clinecd>
<Note/>
</BLine>
<BLine>
<Sourceid>22223</Sourceid>
<TargetID/>
<ModelType>Cars</ModelType>
<ModelName>i10</ModelName>
<PrimaryCode>3</PrimaryCode>
<SecondaryCode>9</SecondaryCode>
<Quantity>1</Quantity>
<Clinecd>(0-n)
<blineId> abc1</blineId>
<blineno>cde1</blineno>
</Clinecd>
<Note/>
</BLine>
<Actach>(0-n)
<Sourceid>32222</Sourceid>
<TargetID/>
<ModelType>Cars</ModelType>
<ModelName>i10</ModelName>
<PrimaryCode>3</PrimaryCode>
<SecondaryCode>9</SecondaryCode>
<Quantity>1</Quantity>
<Clinecd>
<blineId> bc</blineId>
<blineno>de</blineno>
</Clinecd>
<Note/>
</Actach>
<Actach>
<Sourceid>32223</Sourceid>
<TargetID/>
<ModelType>Cars</ModelType>
<ModelName>i10</ModelName>
<PrimaryCode>3</PrimaryCode>
<SecondaryCode>9</SecondaryCode>
<Quantity>1</Quantity>
<Clinecd>(0-n)
<blineId>bc1</blineId>
<blineno>de1</blineno>
</Clinecd>
<Note/>
</Actach>
<Route>(1-n)
<SourceID>765991</SourceID>
<TargetID/>
<SequenceNumber>1</SequenceNumber>
<CLine>(0-n)
<CLineID>33211</CLineID>
<LineID/>
<Status>02</Status>
</CLine>
<CLine>
<CLineID>645332</CLineID>
<LineID/>
<Status>02</Status>
</CLine>
</Route>
<Line>(0-n)
<SourceID>003</SourceID>
<TargetID/>
<Statu>99</Statu>
<ID/>
<L>12.3</L>
<W>2.5</W>
<H>0.83</H>
<Wt>8000</Wt>
<Remark/>
<Charge>
<base>12</base>
<ratio>.2</ratio>
</Charge>
<CLink>
<LineID>645332</LineID>
<Quantity>1</Quantity>
</CLink>
</Line>
</B-king>
</Message>

[Anonymous]

Hi Rajender,

    If you are using tHmap, then why are you using tXmlMap on top of that? You can do the entire work using tHmap itself using Talend Data Mapper.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Rajender]

Hi @nthampi 

I am new to Talend. I am not sure how to extract multiple schema from tHMap. 

I know how to extract multiple schema using tXMLMap but since there is missing tags. So I used tHMap generated missing tags on top of it use tXMLMap.

It would be great, If you can provide some map example to extract multiple schema from tHMap. I gone through example proved in TIS tool but could not grasp it. Timeline to resolve solution is short.

Thanks in Advance.

Regards

Rajender Prasad

[Rajender]

Please suggest the best approach to handle above scenario.

Thanks in Advance

Regards

Rajender Prasad

[Rajender]

Hi Community

Please share talend mapper which has one source and mulitple output for each schema.

Thanks in Advance.

Regards

Rajender Prasad