tFileInputXML parsing issue

Anonymous — Tue, 29 Aug 2017 16:04:43 GMT

I am using tFileInputXML to parse XML files.

My XML file looks similar to as below:

ABCD

</orgname>

<name>

O sullivan

</name>

<street>par street </street>

<state>Alabama </state>

</address>

<examdetails

<subject> maths</subject>

<subject>science</subject>

</examdetails>

Here, I define the Local XPath query as follows:

"/*[local-name()='organisation']/*[local-name()='address']/*[local-name()='street']"

the in Mapping:

column 'street', I use XPath Query as 'text()'

column 'exam' should provide me a value of true if the node 'subject is present in the XML file. Here there are two nodes with subject. How should I define the XPath Query for this. Some XML files do not have the node subject, in that case it should return false. All the XML files contains the node 'examdetails'.

whe I use the XPath query

"../../../*[local-name()='examdetails']/*[local-name()='subject']"

for column exam, I am getting null.

Re: tFileInputXML parsing issue

Anonymous — Thu, 31 Aug 2017 10:42:53 GMT

Hello,

Could you please try to set up xml metadata for your input file to see if it works?

Here is document about:TalendHelpCenter:Centralizing XML file metadata

Best regards

Sabrina

topic tFileInputXML parsing issue in Talend Studio

tFileInputXML parsing issue

Re: tFileInputXML parsing issue