Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I am new to Qlik and wanted a solution for this problem; I want to have an Excel spreadsheet located in some place that it uploads to Qlik bimonthly. I have read a post that offered a solution (below) but I wanted to know where in Qlik or how to put this script.
Hi,
Try below script
LET vFilePath = '\\172.65.58.19\THEDRIVE\LISTING\Traore\LIST\';
FOR EACH file in FileList('$(vFilePath)\*.xlsx'); // Loops each excel file in the given Folder
LET vFileYear = Left(Right(file, 9), 4);
LET vMaxYear = Rangemax(vFileYear, vMaxYear);
NEXT
Data:
LOAD *
FROM
[\\172.65.58.19\THEDRIVE\LISTING\Traore\LIST\Listing $(vMaxYear).xlsx]
(ooxml, embedded labels, header is 5 lines, table is [Listor]);
OK, Thanks,
and how will the script be to connect it to a Google Drive? More specifically a Google Sheet
I am pretty new to Qlik and my programming knowledge its kind of low,
Thanks in advance