Discussion board where members can get started with Qlik Sense.
I am loading data from a database table using a sql like this:
select * from DB.TABLE;
Now I am doing resident load on Table A, like this:
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.
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.
Noconcatenate Load * resident [Table A];
drop table [Table A]
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:
Load * from db.tablename;
Load * from [table A];
Drop table [Table A];