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
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.
Solved! Go to Solution.
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?
We are parsing the xml files by using file xml option
My Input is
Output should be
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?
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.