Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table that is loaded with partial reload as follows:
Client:
ADD ONLY LOAD
Field1,
Field2
FROM
[client.xlsx]
(ooxml, embedded labels, table is Sheet1);
How can I use the dynamic update action of a button to drop this table, permanently?
Hi,
Not sure to understand the logic.
You have a table and you want to drop it from the UI? Am I right?
If it's the case, there is a confusión between back end and front end.
Could you explain the business purpose/ case?
Cheers,
Eva
Hi,
Currently, user can upload a csv file using a partial reload at any time. However, we want to be able to remove this loaded table from the data model at a later time. something like:
drop table myTable;
Hi,
Try like this, you need to again partial reload to drop this table
Client:
REPLACE ONLY Load
*
INLINE [Dummy];
The existing Client table is dropped and again creates the same Client table with some Dummy column with no values.
I think this is the way to DROP the table in Partial reload.
Or the another way is Binary Load this qlikview in another Qlikview file and then use
DROP TABLE Client;
Hope this helps you.
Regards,
Jagan.
But how would I know if the user wants to partial reload the csv or drop an existing one when partial reload is executed. I need to control this from a button with the caption: "Remove External File". And then from there execute a command to drop the table. Button Action doesn't even allow a partial reload , just reload. I was hoping there was a way with the button dynamic update action to accomplish this.