topic Re: How to parse XML in loop and find Index value in Talend Studio

How to parse XML in loop and find Index value

Anonymous — Mon, 09 Oct 2017 03:38:28 GMT

I am trying to parse the XML, need input how to parse the loop (rowdata repated twice) and how to get RepeatIndex value.

<main>

<Desc>Description</Dec>

</rowdata>

<Desc>Description</Dec>

</rowdata>

</ReasonLst>

</main>

Re: How to parse XML in loop and find Index value

Anonymous — Mon, 09 Oct 2017 04:43:28 GMT

Hi
As a newbie, I would suggest you to go Repository->Metadata and create a XML metadata following the wizards, the Loop xpath query element will be set to rowdata.
Let me know if you have any questions.

Regards
Shong

Re: How to parse XML in loop and find Index value

Anonymous — Mon, 09 Oct 2017 14:38:13 GMT

Thanks for the quick response Shong. Actually I followed Metadata -> File XML -> selected all the fields.

1) I am able to get the first occurrence of rawdata, NOT second occurrences.

2) Even the first occurrence I am able to get the Index header within " ", but not the value.

I am looking for these option to get additional fields while parsing.

Re: How to parse XML in loop and find Index value

Anonymous — Wed, 11 Oct 2017 04:08:50 GMT

@shong - I have attached sample XML, I have created metadata for this XML and used this in tFileInputXML. tLogRow shows only below values, rest of the values are not parsing.

Could you please help on this ?

book.xml.xml

Re: How to parse XML in loop and find Index value

Anonymous — Wed, 11 Oct 2017 10:48:15 GMT

Set the Xpath loop query to /x:books/book/ReasonList/rowdata, you should be able to extract all records, see

Regards

Shong

Re: How to parse XML in loop and find Index value

Anonymous — Thu, 12 Oct 2017 04:01:42 GMT

@shong - Thanks for the response.

Now I got couple of rows, there I don't see value 7 / 8 after Index_Reason field. How to get this ?

After parsing...

Since some of the fields are common and only few fields repeated twice, my objective to get single record and repeated fields should be additional columns. So I tried to combine with tDenormalize with id, author, title, genre, price, pub_date, review. It didn't helped. Then followed tMap to copy the files into two different output files and used again tMap to join with above key fields, it created duplicate records and removed with tUniqueRow

Now the results shows as per below (Except the Index Value, I need your input the value). Is there any other better way to do this ?

Re: How to parse XML in loop and find Index value

Anonymous — Fri, 13 Oct 2017 08:55:27 GMT

@New_User wrote:

@shong - Thanks for the response.

Now I got couple of rows, there I don't see value 7 / 8 after Index_Reason field. How to get this ?

See screenshot, you should extract the field Indexes/rowdata to get value 7/8.

Re: How to parse XML in loop and find Index value

Anonymous — Fri, 13 Oct 2017 17:52:17 GMT

@shong - Thanks for the prompt response.

The parsing which I am trying to do is manually specifying XPath for each loop. Is there option do automatically parse with XSD ? So that I don't need to worry about if any other loop with different file ?

Tried tFileInputRaw (read XML file) -> tHMap (input is XML and output is Flat) -> tFileOutputDelimited. In this flow I am not able to get header and there is NO option to specify the delimiter to get it as CSV file. Is there any option to get the schema for the XSD and specify the delimiter for this scenario ?

Looking for option if XML input given then loop through fields as additional rows and comma delimited as output with header.

Please share your thoughts.