loading multiple excel file and excel sheet from aws s3

sanjeev23 — Mon, 21 Nov 2022 11:34:10 GMT

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 .

topic loading multiple excel file and excel sheet from aws s3 in Connectivity & Data Prep

loading multiple excel file and excel sheet from aws s3