How to delete one file after concatinating multiple files in qlik Sense Business?

[Romainscho1]

Hello everyone,

After concatinating multiple files, which is a nice feature, I sometimes need to replace one of them. When you click on the concatinated files and click on the bin, it always delete all of those files. If I loaded files from January - Juin and I wanna replace only the file June, how can I do this without deleting all ?

Thank you, 

[Andrei_Cusnir · Accepted solution]

Hello,

If my understanding is correct, you have loaded data from multiple files and Qlik Sense has concatenated all data in the same table. Now you are looking for a way to remove the data only for 1 file. If this is the use case scenario then you can follow the steps below:

1. Select the bubble with all the concatenated tables
2. On the bottom there is a button that can split the table. Click on the icon 
3. Then unselect all the tables and select ONLY the table that you want to remove from the concatenated table
4. In my use case, I want to remove the table "Sheet 1-2" so I selected only that table: 
5. As soon as you click on "Split" button, you will notice that you ended up with 2 tables. One is the original concatenated table without the one that you have removed, and the other one is the removed table. 
6. You can then delete the table that you have removed and as soon as you reload the data you will notice that values of the removed table are no longer present in the data set.
7. Additionally, you can reimport the table and it will be automatically concatenated with the other table again. 

I hope that this is the information that you were looking for. In case I have misunderstood the use case scenario, please provide further details.

[Romainscho1]

Hi Andrei,

Thanks a lot for this clear explanation, it works perfectly.

Best regards,