Resident Tables in Qlikview

 

Residents are replicas of tables/qvds it does not contain actual data it contains a reference to the data

Creating a resident:

Load Order_ID,Order_Date

Resident Orders;

Drop table Orders;

Incase the structure of both the resident and Table is same then dropping the Table also drops the content of the Resident hence in such a case we can take a extra dummy column to change the structure of the resident

resi_Products:
load CategoryID,CategoryName,ProductID,ProductName,'y' as dump
resident Products;

drop table Products;

(Here dump is an extra column created so that the drop table does not drop the structure of the resident as well since its same as that of the Parent table)