topic Re: XML record count in Talend Studio

XML record count

alevy — Thu, 02 Aug 2012 17:17:25 GMT

I have an XML file in the following format:

<Items>

<Item>

...

</Item>

<Item>

...

</Item>

...

</Items>

I want to read all the details in as normalised records so I set the Loop XPath to "/Items/Item//*" with columns "fn:name()" and ".". So far so good, I get records as follows:

Detail1,A

Detail3,B

etc.

But the problem is there is no unique identifier amongst the various details for each <Item>so how can I create one to link the various detail records, even if it's a simple counter of which <Item>the record is created from? I thought something with fn:position() but I can't make it work.

Thanks

Re: XML record count

Anonymous — Fri, 03 Aug 2012 03:30:28 GMT

Hi
Maybe create a job like this.
tFileInputXML --main-->tMap--main-->tLogRow
In the "outer" of tMap, add a new column and use this column to generate sequence id.
Regards,
Pedro

Re: XML record count

alevy — Sun, 05 Aug 2012 08:15:10 GMT

That would give me a sequence that increments for each detail but I need a sequence that increments for each Item i.e. one level up from my loop.

Re: XML record count

alevy — Wed, 08 Aug 2012 01:44:45 GMT

Anyone have any idea, please?

Re: XML record count

janhess — Wed, 08 Aug 2012 09:39:13 GMT

You could use the count() function in xslt and use the tXSLT component.