topic Re: Drop table in QlikView

Drop table

Kumar6872 — Tue, 28 Apr 2020 14:01:07 GMT

Hello Friends:

Here is the scenario that i am getting error while executing the script.

A1:

Load * from abc.txt;

Store Table_A into c:\test\abc.qvd;

B1:

Load * from xyz.txt;

Store Table_b into c:\test\xyz.txt;

Drop B1;

After running the script i am getting error saying error: Table 'B1' not found

intresting part is both QVD's are created but the dropping table B1 is not happening. Another thing i noticed is that if i add code to drop table A1 then the script executes fine with QVD's are created and table A1 and B1 both are deleted.
Is there any reason that i cannot drop only table B1

Thanks in advance for the help.

Re: Drop table

kaushiknsolanki — Tue, 28 Apr 2020 14:15:18 GMT

It is because,

Your abc.txt & xyz.txt have the same numbers of fields and their names are also the same.

Due to this Qlik by default concatenated both the tables into A1

and thus it couldn't find the table B1 and gave an error.

Re: Drop table

rubenmarin — Tue, 28 Apr 2020 14:23:38 GMT

Just to add that you can use NoConcatenate keyword to avoid that behaviour:

B1: Noconcatenate Load * from xyz.txt; Store Table_b into c:\test\xyz.txt; Drop B1;

So you can access data from B1 table and work with it before dropping it.