Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
gtaware
Contributor
Contributor

How to add Missing TAG in XML file

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>

Labels (3)
0 Replies