topic Re: Drop Tables in QlikView

Drop Tables

alwayslearning — Wed, 25 Nov 2020 16:16:04 GMT

I am having issues with the syntax for dropping multiple table.

I have multiple tables which I have joined and then created a final table where I use all the data and wanted to drop all the other tables but I get a syntax error for DROP TABLES Table1, Table2, Table3; e.g.:

Also with my Table 4: I have used Table1 as Resident but do I need to state Table1, Table2, Table3?

Re: Drop Tables

MarcoWedel — Sun, 12 Feb 2017 21:52:38 GMT

You try to drop tables that do not exist.

Left Join (Table1)
Table2:
LOAD somefields
FROM someyource

does not create a separate Table2 you could drop because it is joined to Table1.

hope this helps

regards

Marco

Re: Drop Tables

Anonymous — Mon, 13 Feb 2017 05:29:33 GMT

Hi,

Use 'NoConcatenate ' before Table 4 and drop 'Table1 ' alone.

Re: Drop Tables

rahulpawarb — Mon, 13 Feb 2017 07:25:51 GMT

Hello Kwok,

I agree with Marco! Tables consumed in join will be available in data model as separate tables. i.e. Table 2 & Table 3 are joined with Table 1; therefore these tables will not available (distinct fields from both the tables will be part of Table 1).

Hope this makes sense.

Regards!

Rahul

Re: Drop Tables

alwayslearning — Mon, 13 Feb 2017 10:48:10 GMT

Thanks Marco.

I understand that logic now. I knew it would just be some kind of lack of understanding on my end.

Re: Drop Tables

alwayslearning — Mon, 13 Feb 2017 10:49:37 GMT

Thank Rahul for the deeper explanation. Has helped with my continued learning of Qlik which I am relatively new to.

Re: Drop Tables

rahulpawarb — Mon, 13 Feb 2017 11:09:06 GMT

We are also learning (or you could say GROWING) day by day. It's a matter of few day's; I am sure that you will be PRO very soon.