Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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