tFileinputXML Component Question

Anonymous — Fri, 04 Dec 2015 17:01:00 GMT

Hi,
I have a XML with tag structure as
<text>
<table>
<tbody>
<tr>
<td> InsuranceName </td>
<td> InsuranceAddress </td>
</tr>
</tbody>
<table>
<text>
In the tFileInputXML component, my LoopXpathQuery is "/text/table"
I want to Pickup only the InsuranceName from the <td> section. What should i be using in the 'Mapping section' in the XPath query for picking up just the Insurance Name ?

Re: tFileinputXML Component Question

Anonymous — Mon, 07 Dec 2015 02:59:18 GMT

The loop element is <td> in this example, so you should set LoopXpathQuery to "/text/table/td" to extract all values of <td>element, filter the values if needed after tFileInputXML.

topic tFileinputXML Component Question in Talend Studio

tFileinputXML Component Question

Re: tFileinputXML Component Question