topic Re: File xml -- Get Loop Index for the xpath in Talend Studio

File xml -- Get Loop Index for the xpath

Anonymous — Fri, 02 Feb 2018 22:35:38 GMT

We are using filexml to parse a xml file.

We have a requirement to find the loop index, is there any xpath expression to populate the counter

Our file looks like

<KEY>

<ITEM>

<F1>value1<F1/>

<F2>value2<F2/>

<ITEM/>

<ITEM>

<F1>value3<F1/>

<F2>value4<F2/>

<ITEM/>

For the above example, my output should be

ITEM value1 value2 1(loop index counter)

ITEM value3 value4 2(loop index counter)

We need to know the loop index for the <ITEM/> when we are parsing in FileXML? Are there any valid xpath expression i can use to determine the counter.

Thanks

Srini

Re: File xml -- Get Loop Index for the xpath

Anonymous — Mon, 05 Feb 2018 03:05:33 GMT

Hello,

Do you want to output a xml file including multiple loop elements?

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

Re: File xml -- Get Loop Index for the xpath

Anonymous — Wed, 21 Feb 2018 20:45:49 GMT

Hi,

We are parsing the xml files by using file xml option

My Input is

<diagnosis>
<code="I10">CODE1</code>
<displayName>CODE1 DESCRIPTION</displayName>
</diagnosis>
<diagnosis>
<code type="I10">CODE2</code>
<displayName>CODE2 DESCRIPTION</displayName>
</diagnosis>

Output should be

CODE1
CODE1 DESCRIPTION
1

CODE2
CODE2 DESCRIPTION
2

For every loop of <diagnosis> we need get the counter.

What functions we can use in file xml to get the counter for the nodes?

Thanks

Srini

Re: File xml -- Get Loop Index for the xpath

Anonymous — Thu, 01 Mar 2018 18:03:22 GMT

This helps count(preceding-sibling::*)+1 in getting the loop index of an XML