topic Re: Basic Resident load issue in QlikView

Basic Resident load issue

apthansh — Sat, 16 Nov 2024 04:38:27 GMT

I have attached qvw as sample..it has basic resident load but it not dropping the final resident table...any thoughts on what I am doing wrong ?

Thanks much

sunny_talwar — Mon, 28 Jan 2019 15:23:48 GMT

Try this

ProjectPipeline:
NoConcatenate
load 
 lineID,
 Total_pp,
 [Expiration Date]
Resident  ProjectPipelineTmp;
drop table  ProjectPipelineTmp;

apthansh — Mon, 28 Jan 2019 15:34:45 GMT

Thank you for your help as always...you are awesome 🙂