loading multiple excel file and excel sheet from aws s3
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
