QVD incremental script

realpixel — Fri, 21 Mar 2014 15:38:39 GMT

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;

Re: QVD incremental script

rajeshvaswani77 — Fri, 21 Mar 2014 15:47:16 GMT

Hi,

Please see attached document.

thanks,

Rajesh Vaswani

javier_florian — Fri, 21 Mar 2014 16:12:12 GMT

Hi RealPixel,

Check this discussion:

-JFlorian