topic Re: Read first/last row of XML in Talend Studio

Read first/last row of XML

aashish_21nov — Fri, 27 Jul 2018 06:33:43 GMT

How to read first and last row of XML file.

Thanks in advance

Re: Read first/last row of XML

Anonymous — Fri, 27 Jul 2018 07:06:23 GMT

Hi,

While reading the file, you can pass the ((Integer)globalMap.get("tFileInputXML_1_NB_LINE")) parameter also to the subsequent data flow and use this value to pick the first and last rows.

Warm Regards,

Nikhil Thampi

Re: Read first/last row of XML

aashish_21nov — Fri, 27 Jul 2018 07:15:56 GMT

where should I pass NB_LINE

Re: Read first/last row of XML

aashish_21nov — Fri, 27 Jul 2018 07:18:54 GMT

or is there any way to read a file in reverse order like the last record then second last and so on.

Re: Read first/last row of XML

Anonymous — Fri, 27 Jul 2018 07:28:24 GMT

Hi,

My sincere apologies as I read the requirement slightly different way. If you want to read the line numbers for each column, the best way is to add a sequence and transfer the data to an additional line number column.

I have shown it for a delimited file but the theory remains same for xml file also.

Warm Regards,

Nikhil Thampi

Re: Read first/last row of XML

Anonymous — Fri, 27 Jul 2018 07:29:44 GMT

Hi,

Once you got the line numbers for each row, you can choose the data in any order using a tsortrow and tfilterrow components.

Warm Regards,

Nikhil Thampi

Re: Read first/last row of XML

aashish_21nov — Fri, 27 Jul 2018 07:38:03 GMT

actually, we are just finding the shortest/smartest way to validate XML files.