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;
