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: 
Anonymous
Not applicable

Add a custom row at the top of a delimited file?

Hey,

 

Is there an easy way for me to add a row at the top of a csv file with arbitrary text? The system we are doing integration for requires a "function" at the top of the CSV so it understands what to do with the file in addition to the headers. This has to be written to every file. So basically the format is:

 

[Function]

col1;col2;col3;col4

data;data;data;data

data;data;data;data

...

 

/Jani

Labels (3)
1 Solution

Accepted Solutions
manodwhb
Champion II
Champion II

@janiarp,by using tFixedInput in the flow first create required data in file output and then append the data the same file in data flow.

View solution in original post

2 Replies
manodwhb
Champion II
Champion II

@janiarp,by using tFixedInput in the flow first create required data in file output and then append the data the same file in data flow.

Anonymous
Not applicable
Author

Hi Manohar,

Thank you for a swift reply, this is exactly what I was looking for!

/Jani