Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
sroy
Contributor
Contributor

Unable to load files from S3 into Qliksense

Hello,

I have last 1 years monthly files in S3 and is trying load them in Qliksense by connecting through web connector. 

I am using the below script

Load * from 

[http://<servername>:5555/data?connectorID=AmazonS3Connector&table=ListObjects&region=eu-west-1&accessKey=abcd&secretKey=xyz&bucketName=s3-euw1-bi&prefix=dev%2fstage%2fqliksense&%2fSAP_B1_BERNAQUA%2fBQ50_AvoirsDoc_202001.CSV&appID=]

(txt, codepage is 1252, embedded labels, delimiter is '|', msq);

Until this works fine for loading only 1 file. 

However I am struggling to write a loop script for reading files from 202001 to 202104 using the above script?

Could you please help?

Thanks in advance

Regards,

Roy

 

 

 

0 Replies