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: 
ananyaghosh
Creator III
Creator III

Resident load problem - please help

Hi,

I am loading data from a database table using a sql like this:

[Table A]:

select * from DB.TABLE;

Now I am doing resident load on Table A, like this:

[Table B]:

Load * resident [Table A];

drop table [Table A];

but my problem is [Table B] is not generating in data model. So my question is when I resident table from another table using sql query, it will not generate? I am doing thing this in QlikSense.

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

your problem is your Table B has the exact same fields as Table A

so automatically the two table are merged

change your script to.

[Table A]:

select * from DB.TABLE;

[Table B]:

Noconcatenate Load * resident [Table A];

drop table [Table A]

arvind1494
Specialist
Specialist

Becuase you are loading table B which has the same fileds as Table B

and Concatenation come into picture to merge Table b into A

so after loading you are getting error as Table B not found:

Solution:

[Table A]:

Load * from db.tablename;

Noconcatenation;

[Tabe B]:

Load * from [table A];

Drop table [Table A];