tFileinputXML Component Question

One Star

tFileinputXML Component Question

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 ?
Community Manager

Re: tFileinputXML Component Question

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.
----------------------------------------------------------
Talend | Data Agility for Modern Business