Save a Table each day to the bottom of a file

[RichardLee]

Hi All,

I need some help with this please?

I have a table that is loaded each morning I have a script at the end of the load to save the table as an Excel file. But  need to save each day as new data at the bottom of the sheet so I have the load date as a selectable.

How can I do this?

Thanks for any help 

[durgesh22]

Use below approach

//****************************************//

QV_Table:

Load Date,X,Y from <New_data_file>;
Concatenate LOAD Date, X, Y FROM AlreadySavedFile;

STORE QV_Table INTO AlreadySavedFile;

//****************************************//

for more information refer below link

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/LoadData/use-QVD-fil...

[RichardLee]

Thanks for the quick reply