Resident load problem - please help

[ananyaghosh]

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.

[lironbaram]

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]

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];