topic tFileInputXML component "Loop XPATH query" issue in Talend Studio

tFileInputXML component "Loop XPATH query" issue

DataEngineer1978 — Sat, 16 Nov 2024 00:51:24 GMT

Good Morning,

I need an example of how to input the tFileInputXML ---> Loop XPath query --> What goes in here?

Say I have an xml with this structure:

<Customer_name>John Smith</Customer_name>

Customer_Id>123456</Customer_Id>

</Customer>

</Customers>

So what goes in the Loop XPath Query based on the above example structure?

DataEngineer1978 — Thu, 07 Jan 2021 16:15:51 GMT

Is this the same as the mapping field?

DataEngineer1978 — Thu, 07 Jan 2021 16:35:42 GMT

What would go in the XPathQuery for the "Mapping" section. Is the XPath query in quotes or not in quotes?

Anonymous — Fri, 08 Jan 2021 03:05:52 GMT

We usually create the file metadata before it is used. Go to Repository->Metadata and create a XML metadata under File XML node.

In the job, select 'Repository' in Property Type list and select the file metadata from repository.

Regards

Shong