Test Presenza di File

[#1]

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

[Anonymous]

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