Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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®ion=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