HI,
I have to upload multiple excel file and sheet from aws, so every time a new excel drop on that path,it will automatically get update into app. i am using qliksense saas
while i am trying this, the output i am getting is only the name of all the excel file but data line fetched :0.
each excel sheet have different name .one excel file
for example: excel file name: Imp Engines Apr - Final Format.xlsx and multiple sheet: del , hgk, jk, hk, the, etc.
the code i m writing is:
LIB CONNECT TO 'Amazon_S3';
let file ='lib://Amazon_S3/';
for each file in filelist('lib://Amazon_S3/')
IF WildMatch('$(file)','*.xlsx') THEN
LOAD
*
FROM [$(file)];
END IF
next file
kindly suggest what should I do .
