4 Replies Latest reply: May 16, 2017 2:44 PM by Jeb Pittard RSS

    Load Only New Records from SQL

    Jeb Pittard

      I want to load only new records. When I run this script, I get an error, but if I take out the Concatenate, it replaces the old QVD with the new criteria. What am I doing wrong?

      thanks

       

       

      CONCATENATE

      LOAD *;

      SQL SELECT *

      FROM "GL_Transactions".dbo."GL_Transactions"

      where [Transaction Effective Date] >='12/31/2016' ;

       

       

       

       

      store GL_Transactions Into ....\qlikview\99.Shared_Folders\2.QVD\2.QVD_Data\GL_Transactions.qvd (qvd);

       

       

      drop Table GL_Transactions;