Basic Resident load issue

[apthansh]

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 · Accepted solution]

Try this

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

[apthansh]

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