Test Presenza di File

Wed, 23 Mar 2016 09:35:16 GMT

E' possibile testare la presenza di un file, in un DB SQLServer, da caricare tramite ETL Qlik ?

Re: Test Presenza di File

Anonymous — Thu, 24 Mar 2016 05:36:57 GMT

Fare riferimento di seguito lo script vi aiuterà a implementare la soluzione per voi problema :

let vDateToday=Floor(num(date(now())));

let vMonthDay = Day(now())&' '&Month(now())&' '&year(now());

set vSourceFilePath='D:\Daily Sales Tracker\Source Data\';

set vSourceQVDPath='D:\Daily Sales Tracker\QVD\';

set vQVDBKPPath='D:\Daily Sales Tracker\Backup\QVD Backup\';

Excel:

LOAD * INLINE [

Table

Target

Budget

Channel

Country

HolidayTracker

Product

SalesTransaction

];

//*******************************************************Smart File Wtcher************************************************

for i=0 to 6

let vFileName=peek('Table',$(i),'Excel');

let vFileDate=Floor(num(Date(FileTime('$(vSourceFilePath)$(vFileName).xlsx'))));

if $(vFileDate)= $(vDateToday)-1 then

Set vFileAlert='$(vFileName) Received';

else

Set vFileAlert='Error***************$(vFileName)file not Received.....!!!'****************;

set vFLincorrect='1';

end if

next i

if $(vFLincorrect)=1 then

'Some files are not Received...!!';

Exit Script;

end if