tFileInputXML component "Loop XPATH query" issue

[DataEngineer1978]

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:

<Customers>

<Customer>

<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]

Is this the same as the mapping field?

[DataEngineer1978]

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

[Anonymous]

Hi

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