10 Replies Latest reply: Oct 5, 2017 11:31 PM by Shwu Hua Gan RSS

    Where Not Exist - not working

    Shwu Hua Gan

      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.