Drop Tables

[alwayslearning]

Hi

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?

[MarcoWedel · Accepted solution]

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

[Anonymous]

Hi,

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

[rahulpawarb]

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

[alwayslearning]

Thanks Marco.

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

[alwayslearning]

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

[rahulpawarb]

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.