Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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".