topic Read file content from s3 in Qlik Automate

Read file content from s3

xyz_1011 — Tue, 12 Sep 2023 09:27:45 GMT

Hi all,

is it possible to fetch the whole content from a file that is stored in s3 and store the content in a variable ? - I did play around with the Read data block, but it appears this seems to only put one line at a time into my variable...any idea how i could get the full file content into one variable ?

Thanks in advance!

Re: Read file content from s3

Shai_E — Tue, 12 Sep 2023 11:51:09 GMT

Hi @xyz_1011 ,

Just a suggestion, i remember some time ago taking an output block and inserting it at the end of a loop block, if i remember correctly this gets the whole list rather then one element from the list each time if you insert the output block inside the loop.

Best Regards

Re: Read file content from s3

xyz_1011 — Tue, 12 Sep 2023 14:01:46 GMT

Hi @Shai_E - indeed. I put the variable outside of the loop and it then gets set with the full content of the file. Thanks.