Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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?


Tags (2)
1 Solution

Accepted Solutions
Highlighted

Re: Drop Tables

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
Highlighted

Re: Drop Tables

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

Highlighted
Contributor III
Contributor III

Re: Drop Tables

Hi,

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

Highlighted
Specialist III
Specialist III

Re: Drop Tables

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

Highlighted
Creator
Creator

Re: Drop Tables

Thanks Marco.

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

Highlighted
Creator
Creator

Re: Drop Tables

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

Highlighted
Specialist III
Specialist III

Re: Drop Tables

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.