Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
Hello,
Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina