Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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 ?
Labels (3)
1 Reply
Anonymous
Not applicable
Author

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.