topic Re: Read Multiple Nested loop in database in Talend Studio

Read Multiple Nested loop in database

Rajender — Sun, 24 Feb 2019 08:26:19 GMT

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-loops/m-p/54536

Re: Read Multiple Nested loop in database

Rajender — Sun, 24 Feb 2019 18:29:11 GMT

Hi Community

I have used tXMLMap component to resolve problem. But as BLine, Acatch and Line are 0 to unlimited node. Because of which I am looking B-King Data.

What i Mean is B-King has 5 records for which only one BLine record. For B-King Configure source loop is set B-King/BLine/Clinecd/BlineId. In my final output, I have only one records not 5 records.

Please help.

Re: Read Multiple Nested loop in database

Anonymous — Mon, 25 Feb 2019 05:01:10 GMT

Hi Rajender,

The loop will have to be at the same level if you want to extract multiple records from an XML.

Could you please share the current XMLMap screen shot, current output and desired output so that we will get an idea about the flow you are trying to do?

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 🙂

Re: Read Multiple Nested loop in database

Rajender — Tue, 26 Feb 2019 06:26:12 GMT

Hello @nthampi

thanks for your time.

Loops are at multilevel to extract information. Issue was with data type BYTE is giving error as data is character N. To resolve it I have changed source datatype string from byte.

Is there any other way to handle data type conversion.

Regards

Rajender Prasad

Re: Read Multiple Nested loop in database

Anonymous — Tue, 26 Feb 2019 10:32:08 GMT

Hi Rajender,

The byte data type description is as shown below.

"byte: The byte data type is an 8-bit signed two's complement integer. It has a minimum value of -128 and a maximum value of 127 (inclusive). The byte data type can be useful for saving memory in large arrays, where the memory savings actually matters. They can also be used in place of int where their limits help to clarify your code; the fact that a variable's range is limited can serve as a form of documentation."

So if the value of the incoming data is "Y" or "N", you need to do a condition check in tMap before inserting them to target column. For example, if the value is "N", you can insert 0 and if the value is "Y", then insert "1".

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 🙂

Re: Read Multiple Nested loop in database

Rajender — Tue, 26 Feb 2019 16:47:22 GMT

As I am using tXMLMap to extract output. I am not getting expected output. I observe that Input xml file have some missing tags which is define with occurrence 0-1 or 0-n.

Is it possible to get multiple output from Talend Mapper.

Following is example XML and expected output.

Please help. Thanks in Advance.

B-king
Sourceuid|Targetid|B-kingSourceID|BoNumber|BStatus|CAStatus
11111||0017650|1|0

BLine and Actach
SourceID|Targetid|B-kingSourceID|ModelType|ModelName|PrimaryCode|SecondaryCode|Quantity|TYPE
22223||11111|Cars|i10|3|9|1|1|BLine
32222||11111|Cars|i10|3|9|1|1|Actach

Clinecd
BlineId|BLineSourceID|Bilneno
abc|22222|cde|BLine
abc1|22223|cde1|BLine
bc|32222|de|Actach
bc1|32223|de1|Actach

Route
SourceID|TargetID|B-kingSourceID|SequenceNumber
765991||11111|1

cline
ClineID|RouteID|status
3321|765991|02

Line
SourceID|TargetID|B-kingSourceID|Statu|ID|L|
003|11111||99

CLink
LineID|Quantity|LineID
645332|1|003

Re: Read Multiple Nested loop in database

Anonymous — Wed, 27 Feb 2019 04:22:08 GMT

Hi,

If a tag is missing, it will allocate Null value to the output section.

So you need to add a Null check condition as additional step and map them to target values to be passed.

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 🙂

Re: Read Multiple Nested loop in database

Rajender — Wed, 27 Feb 2019 17:31:09 GMT

Hi @nthampi

Thanks for your Time.

Null check condition, Did you mean in expression something like " isnull(input)? default: input ".

Due to missing tags, Is it possible that tXMLMap does not map tags properly. Its observe value of data mismatch.

Regards

Rajender Prasad

Re: Read Multiple Nested loop in database

Anonymous — Thu, 28 Feb 2019 05:57:50 GMT

Hi,

You are right. If the data is missing, you need to fill them with default data.

Could you please try and let us know the results?

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 🙂

Re: Read Multiple Nested loop in database

Rajender — Fri, 01 Mar 2019 06:16:00 GMT

Hi @nthampi

I have used thmap --> txmlmap. thmap is used to provide all the missing tags then TXMLMap to load all schema into file.

Please suggest is it right approach to load multiple schema XML.

One more thing, thmap has a datatype character with value 01 but final output of tXMLMap datatype character is 0 only.

Is tXMLMap character datatype accept/return only 1 character.

Thanks in Advance.

Regards

Rajender Prasad

Re: Read Multiple Nested loop in database

Anonymous — Fri, 01 Mar 2019 09:59:32 GMT

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 🙂

Re: Read Multiple Nested loop in database

Rajender — Fri, 01 Mar 2019 16:42:26 GMT

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

Re: Read Multiple Nested loop in database

Rajender — Tue, 05 Mar 2019 05:18:25 GMT

Please suggest the best approach to handle above scenario.

Thanks in Advance

Regards

Rajender Prasad

Re: Read Multiple Nested loop in database

Rajender — Mon, 11 Mar 2019 12:35:42 GMT

Hi Community

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

Thanks in Advance.

Regards

Rajender Prasad