Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Myself1
Contributor III
Contributor III

Removing line from xml file

Hi,

Here's an example of XML files that my job is generating

<?xml version="1.0" encoding="UTF-8"?>

<time_slots>

 <time_slot>

   <Field name="tsid">1</Field>

   <Field name="tsname">07-09</Field>

   <Field name="tslabel">07-09</Field>

   <Field name="tsstatus">inactive</Field>

   <Field name="tstime_from">07:00:00</Field>

   <Field name="tstime_to">09:00:00</Field>

 </time_slot>

 <time_slot>

   <Field name="tsid">2</Field>

   <Field name="tsname">08-12h30</Field>

   <Field name="tslabel">080000130000</Field>

   <Field name="tsstatus">active</Field>

   <Field name="tstime_from">08:00:00</Field>

   <Field name="tstime_to">12:30:00</Field>

 </time_slot>

</time_slots>

I would like to remove the first line <?xml version="1.0" encoding="UTF-8"?>, to be able to concat several XML files, how to do that ?

Regards,

Labels (3)
1 Solution

Accepted Solutions
Anonymous
Not applicable

@JC JC​ after generating the XML file, read the file line by line using tFileInputFullRow, set the header as 1 to skip the first line, re-generate the file using tFileOutputDelimited.

 

 

View solution in original post

2 Replies
Anonymous
Not applicable

@JC JC​ after generating the XML file, read the file line by line using tFileInputFullRow, set the header as 1 to skip the first line, re-generate the file using tFileOutputDelimited.

 

 

Myself1
Contributor III
Contributor III
Author

So simple !

 

Thanks