topic Re: XML Input in Talend Studio

XML Input

sonalijagtap — Tue, 21 Aug 2018 12:34:34 GMT

Hi Team,

below is my sample xml data.

My loop is on "/test"

in the xpath query for id, I am writing "node/@id", but it is giving me first entry only where id=1.

but i want all the id's, also I don't want to change the loop because other fields are related on that loop only. what should be the xpath query to get all the id's?

Thank You,

Sonali Jagtap

Re: XML Input

fdenis — Tue, 21 Aug 2018 13:09:02 GMT

try to getout the full node then loop on node.
good luck

Re: XML Input

iamabhishek — Tue, 21 Aug 2018 13:31:54 GMT

Try this way -

Re: XML Input

sonalijagtap — Tue, 21 Aug 2018 13:42:43 GMT

Hi,

I will not work in my case.

My loop will be on /test only. because there are other nodes as well along with "/test/node".

So my loop has to be on "/test"

I need to change the xpath query for id to get all the id's present in "node".

Thank You,

Sonali Jagtap

Re: XML Input

fdenis — Tue, 21 Aug 2018 14:01:53 GMT

when you are converting XML to Row the loop define the number of row.
if you are on test --> x ¨row
if you are on node --> x*y row
Regards

Re: XML Input

sonalijagtap — Tue, 28 Aug 2018 09:34:12 GMT

Hi, Please find my sample file,

I want all the data for StoreID=319 Please help me with the correct XPATH Query & Loop. Thank You, Sonali Jagtap

Re: XML Input

fdenis — Tue, 28 Aug 2018 11:08:54 GMT

xml is structured data as tree.
your stored id give you 2 dataset
one for Product
one for DayPartitioning
so you have to read your file 2 time one for each
then match on stored Id

to avoid 2 time reading you can split xml 2 header nodes as documents.