topic Re: Dynamic Drop in QlikView

Dynamic Drop

Thu, 16 Oct 2014 01:02:11 GMT

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?

Re: Dynamic Drop

Thu, 16 Oct 2014 01:09:33 GMT

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

Re: Dynamic Drop

Thu, 16 Oct 2014 01:53:24 GMT

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;

Re: Dynamic Drop

jagan — Thu, 16 Oct 2014 02:13:22 GMT

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.

Re: Dynamic Drop

Thu, 16 Oct 2014 02:40:07 GMT

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.