Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Drop table

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.

2 Solutions

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Drop table

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.

 

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

Highlighted

Re: Drop table

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.

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Drop table

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.

 

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

Highlighted

Re: Drop table

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.

View solution in original post