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.
Try below script
LET vFilePath = '\\18.104.22.168\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);
(ooxml, embedded labels, header is 5 lines, table is [Listor]);