Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
E' possibile testare la presenza di un file, in un DB SQLServer, da caricare tramite ETL Qlik ?
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