Append data to an existing table

[Piro822]

Hello,

Is it possible to append data to an existing table using a select?

Let's say that I have in a table A data from yesterday and I want to do a select for updating the table A with new data from today without loosing the data from yesterday. I noticed that when selecting data from today it replaces the whole table.

Thank you in advanced for your help.

[Piro822]

Hello again,

Finally I have found the solution!!! I have to put lib:// with an existing folder in my data connections. Then it works.

Thank you so much for all the help.

[anushree1 · Accepted solution]

Well in this case I recommend , you check few things here

1. In case you are concatenating the data, it means you must have had the old data in the qvd file and it must be existent

2. Check if the path specified for the qvd is correct, you can check this by trying to load from the qvd on another tab and see the path

3. In case you are using QV 12 , few users are seen to have reported this issue , and have said it is solved either when close and reopen the sample and try this action, and also by not using relative path. Please try the above and check if it helps

[Piro822]

Thank you so much for the answer!!! yes...yesterday I saw the solution like you say in the Qlik help and now it is working.

Regards.