0

I am extracting data from the XML . In that i have two duplicate tag with different values . So how can i get this data in different columns ? 

<table>
  <tr>
    <td>A</td>
    <td>B</td>
  </tr>
  <tr>
    <td>A1</td>
    <td>B2</td>
  </tr>
</table>

So , i want to get those values in different columns . How can i achieve this ? Any help would be appreciated.

AlainD
  • 6,187
  • 3
  • 17
  • 31
Abhishek
  • 21
  • 8

1 Answers1

1

The difficult part is to make kettle to understand in which column to put the result.

  1. In the Content panel, define the Loop XPath as being "/table/tr". That will make the PDI to produce on row per tag.
  2. In the Field panel, define a first column named "col1" with XPath as "td[1]", and a second column named "col2" with XPath "td[2]".

If the column number is dynamic, you need metadata injection.

For your info, the repeat checkbox is not to repeat a field, it is to instruct for Kettle to pick the value of the previous row in case a field is missing on a row.

enter image description here

AlainD
  • 6,187
  • 3
  • 17
  • 31
  • Thanks AlainD , you really saved my day , But buddy i am facing one more issue to , i have following xml format . In that i want to take paragraph values so how can i achieve that . I have tried one way that i mentioned into the comment – Abhishek Mar 16 '18 at 07:46
  • ` Overview: Test Anemia 07/30/2015 ` – Abhishek Mar 16 '18 at 07:56
  • Here is the link : https://drive.google.com/open?id=1QohXTPK-me8Di3Yfu4VI-IhhqN5Oe_r_ https://drive.google.com/open?id=1PO9wR_WVlcCuiJxpXIGWjhBFmq6EeZYj – Abhishek Mar 16 '18 at 08:04
  • Have you tried `loop XPath` = /tbody/tr/td and `field XPath` = paragraph[1], paragraph[2]. If yes, open a new question with the xml and what you want to see. – AlainD Mar 16 '18 at 12:07