How to split a row?

Anonymous — Thu, 12 Sep 2019 23:38:02 GMT

I am new to Talend. Over a few steps i got a xml String below

<xml>
  <header>
    <qrysql>select vbillcode,billmaker,pk_supplier,creationtime,modifiedtime from po_order</qrysql>
    <errcode>ERR000</errcode>
    <msg>success</msg>
  </header>
  <content>
    <group>
      <creationtime>2016-03-22 13:35:46</creationtime>
      <pk_supplier>1001QW10000000004CT2</pk_supplier>
      <vbillcode>CD2016032200000001</vbillcode>
      <modifiedtime>2016-03-22 13:36:17</modifiedtime>
      <billmaker>1001QW1000000000017S</billmaker>
    </group>
    <group>
      <creationtime>2016-03-23 16:05:30</creationtime>
      <pk_supplier>1001QW10000000004CRS</pk_supplier>
      <vbillcode>CD2016032300000006</vbillcode>
      <modifiedtime>null</modifiedtime>
      <billmaker>1001QW1000000000BT8L</billmaker>
    </group>
    .
    .
    .
  </content>
</xml>

My case is to split this string and put each content of <group> tag into a queue of redis.

But i don't how to do that with Talend job components.

Any help is appreciated.

Re: How to split a row?

Anonymous — Fri, 13 Sep 2019 12:55:26 GMT

Max,

In attachment of this reply: two images that illustrates how to do it.

I did the splitting part by using tExtractXMLField.

How your XML will be deliverd, no idea, so I used a tFixedFlowInput component. At the moment Talend has no build in Redis components...

Hope it helps! If you have any questions, just let me know.

Kr,

Jvl7

topic Re: How to split a row? in Talend Studio

How to split a row?

Re: How to split a row?