Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alwayslearning
Creator
Creator

Drop Tables

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?


1 Solution

Accepted Solutions
MarcoWedel

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

View solution in original post

6 Replies
MarcoWedel

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
Not applicable

Hi,

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

rahulpawarb
Specialist III
Specialist III

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
Creator
Creator
Author

Thanks Marco.

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

alwayslearning
Creator
Creator
Author

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

rahulpawarb
Specialist III
Specialist III

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.