File xml -- Get Loop Index for the xpath

Highlighted
Five Stars

File xml -- Get Loop Index for the xpath

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

 

<REPORT>

      <HEADER>

                 <KEY>

      <ITEM>

                 <F1>value1<F1/>

                <F2>value2<F2/>

     <ITEM/>

     <ITEM>

              <F1>value3<F1/>

              <F2>value4<F2/>

     <ITEM/>

    <HEADER/>

    <REPORT/>

 

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


Accepted Solutions
Six Stars

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

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


All Replies
Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

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

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

Six Stars

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

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads