Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
realpixel
Creator
Creator

QVD incremental script

Hello,

I use this script under to connect on SQL dadate base, I want  to use a QVD file with incremantal function to reload my script.

QVD file must be stored in the following path "C:\Qlikview_Rapports"

Someone can help me to modify my script?

ODBC CONNECT TO PrintFiles (XUserId is LfBJQZFMKC, XPassword is VEaMBANORDbGXQBIXF);

Data1:

LOAD PUser as SAMAccountName,

    PDoc,

    PPrinter,

    DDat,

    if(Right([DDat],2) <> 00, Date(Date#([DDat],'YYYYMMDD'),'DD/MM/YYYY')) as DATE,

    //Time(time#([DDat],'hhmmss'),'hh:mm:ss') as HEURE,

    Times,

    NBPage,

    NBCopy,

    NBSigh; 

   

  

SELECT * FROM PrintFiles.dbo.HistoPrinter;

2 Replies
rajeshvaswani77
Specialist III
Specialist III

Hi,

Please see attached document.

thanks,

Rajesh Vaswani

javier_florian
Creator III
Creator III

Hi RealPixel,

Check this discussion:

Incremental Load

-JFlorian