Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Uploads getting stuck in the virus scanner. We are investigating.
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Where Not Exist - not working



LOAD No_ as AccountNo

FROM $(pQVDExtractPath)AU_GLAccount.qvd (qvd) ;

LOAD No_ as AccountNo from $(pQVDExtractPath)TEC_AU_GLAccount.qvd (qvd) WHERE NOT Exists(No_);

In AU_GLAccount.qvd, there are 6 accounts starts with 413

In TEC_AU_GLAccount.qvd, there is an additional account 4131010.

If the script works, I expect to see 7 413 accounts. But, it does not work.

It only shows me what is in AU_GLAccount.qvd.

Help, please.

10 Replies
Contributor III
Contributor III

Hi Anand,

I originally reported the problem.  With your help your earlier,  it has work for mine now. 

I just need to switch the sequence to   WHERE NOT Exists(AccountNo,No_) and data is loaded correctly to 1 table "Account_Hierarchy".