topic Re: Qlikview sending straight table data to existing csv file in QlikView

Qlikview sending straight table data to existing csv file

BSCIknowlec — Sat, 16 Nov 2024 18:09:42 GMT

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

Re: Qlikview sending straight table data to existing csv file

Miguel_Angel_Baeyens — Fri, 11 Sep 2020 11:11:16 GMT

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.