Where Not Exist - not working

[mcsshg2011]

Hi,

AccountHierarchy:

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.

[mcsshg2011]

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".