Extract xml field and merge outputs

Anonymous — Mon, 11 Nov 2019 14:56:48 GMT

Hi All,

i want to get value of a xml looping field as an array.

below the XML doc :

<COMMAND>
    <TYPE>SUBBILRESP</TYPE>
    <TXNSTATUS>200</TXNSTATUS>
    <TXNID>XX191111.1108.A00026</TXNID>
    <DATA>
        <DETAILS>
            <COMPANYCODE>000547</COMPANYCODE>
            <ACCOUNTNO>123456789</ACCOUNTNO>
            <PREF1NAME>AccountNumber</PREF1NAME>
            <PREF1VALUE>123456789</PREF1VALUE>
        </DETAILS>
        <DETAILS>
            <COMPANYCODE>000500</COMPANYCODE>
            <ACCOUNTNO>1236789</ACCOUNTNO>
            <PREF1NAME>AccountNumber</PREF1NAME>
            <PREF1VALUE>123456789</PREF1VALUE>
        </DETAILS>
        <DETAILS>
            <COMPANYCODE>000500</COMPANYCODE>
            <ACCOUNTNO>12</ACCOUNTNO>
            <PREF1NAME>AccountNumber</PREF1NAME>
            <PREF1VALUE>123456789</PREF1VALUE>
        </DETAILS>
    </DATA>
    <MESSAGE>Transaction Details: NA wallet of provider TIGO is debited with service charge  0.00 FCFA, Commission 0.00 FCFA and  tax 0.00 FCFA.</MESSAGE>

    <TRID>778888888201911111108A0034</TRID>
</COMMAND>

i need to get the list of ACCOUNTNO

below is my extractFields component

but at the end i'm getting two rows :

[INFO ]: mfs_new.billeraccountmgt_0_1.BillerAccountMgt - tLogRow_1 - Content of row 1: <?xml version="1.0" encoding="UTF-8"?>
<ACCOUNTNO>123</ACCOUNTNO>
<?xml version="1.0" encoding="UTF-8"?>
<ACCOUNTNO>123</ACCOUNTNO>
[INFO ]: mfs_new.billeraccountmgt_0_1.BillerAccountMgt - tLogRow_1 - Content of row 2: <?xml version="1.0" encoding="UTF-8"?>
<ACCOUNTNO>123456789</ACCOUNTNO>
<?xml version="1.0" encoding="UTF-8"?>
<ACCOUNTNO>123456789</ACCOUNTNO>

and i want to get want to build a string like this :

"ACCOUNTNO1#ACCOUNTNO2#ACCOUNTNO3"

Re: Extract xml field and merge outputs

Anonymous — Mon, 25 Nov 2019 13:22:25 GMT

Hi
After you get the Account No, add a new column with a fixed value, and then use tDenormalize to denormalize the input rows, it will output only one string as you expected.

Regards
Shong

topic Re: Extract xml field and merge outputs in Talend Studio

Extract xml field and merge outputs

Re: Extract xml field and merge outputs