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

    Where Not Exist - not working

    Shwu Hua Gan





      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.