Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Retrieve node position in xml using TFileInputXML

Hi,

 

I'm trying to extract some values from an xml file using a TFileInputXML component.

The xml file can contain several documents in it (from 1 to 1000 for example)

The Xpath loop query is the following one : "/Documents/Document"

 

Retrieving fields for each document is ok. But now I would like to retrieve position of each document in my xml file and store it in a field named cpt.

I've tried with the xpath function position() but it's returning an empty value.

 

In my case, the mapping is the following one :

 

Column = cpt

XPath query = "position()"

 

So can anyone can help me about the xpath query syntax ?

 

Thank you very much !

Labels (3)
1 Reply
Anonymous
Not applicable
Author

Hello,

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

Best regards

Sabrina