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: 
BSCIknowlec
Contributor III
Contributor III

Qlikview sending straight table data to existing csv file

Hi experts,

i have a QlikView app that has numerous dynamic calculations based on a number of factors. once complete, a straight table is produced with 4 columns of data. im looking to then be able to send this data to an existing csv file that keeps a record of all data.

 

im unable to do this in the script as the end results constantly change due to user input on the front end. so instead of just exporting it to excel and then the customer copying that data into their master file, i want to automate this for them that when they press a button, it sends the straight table data to the specific csv file to them.

any ideas? 

 

thank you,

Ciarán

Labels (3)
1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

That's not a native functionality, as you have observed the contents of an object are exported into different files, each time the Export function is called, even if for the same user, app and session.
You can definitely develop a custom piece of code in Javascript for example that appends the contents from one file to another and then deletes the first file.
Also, depending on the expressions of that table, it could be done in the script, creating a table which produces exactly the same results (rows and columns) which you can STORE into a TXT/CSV file. STORE itself does not append, but you can always LOAD the existing file, CONCATENATE the new results and STORE the concatenated table into the original file.

View solution in original post

1 Reply
Miguel_Angel_Baeyens

That's not a native functionality, as you have observed the contents of an object are exported into different files, each time the Export function is called, even if for the same user, app and session.
You can definitely develop a custom piece of code in Javascript for example that appends the contents from one file to another and then deletes the first file.
Also, depending on the expressions of that table, it could be done in the script, creating a table which produces exactly the same results (rows and columns) which you can STORE into a TXT/CSV file. STORE itself does not append, but you can always LOAD the existing file, CONCATENATE the new results and STORE the concatenated table into the original file.