How to add Missing TAG in XML file

gtaware — Fri, 22 May 2020 08:18:05 GMT

Hi Team ,

here is sample XML I am having . Lets say using this File I am creating a CSV file like

Name,Value

ID ,123

NAME,Jani

STREET,321 FAKE St.

STATE, CA

Now if there is TAG - ID which is missing from my XML then my Job will generate below data :

Name,Value

ID ,

NAME,Jani

STREET,321 FAKE St.

STATE, CA

I knew that Tag "ID" is missing from my XML file . My requirement is How to add this TAG back to my Original XML file .

Sample XML File :

<?xml version="1.0" encoding="UTF-8"?>
<sample>
<ID>123</ID>
<NAME>Jani</NAME>
<ADDRESS>
<STREET>321 FAKE St.</STREET>
<STATE>CA</STATE>
</ADDRESS>
<ADDRESS>
<STREET>543 ABCD St.</STREET>
<STATE>UT</STATE>
</ADDRESS>
<ADDRESS>
<STREET>987 SURE Ave.</STREET>
<STATE>OH</STATE>
</ADDRESS>
</sample>

topic How to add Missing TAG in XML file in Talend Studio

How to add Missing TAG in XML file