topic Re: How to read a csv file from data-files within a Automation? in Qlik Automate

How to read a csv file from data-files within an Automation?

FH1620 — Mon, 04 Mar 2024 11:00:51 GMT

Hello,

My Qlik Automation has to read a csv file that is stored in the Qlik DataFiles section. How can I implement it?

Thanks

Eric

Re: How to read a csv file from data-files within a Automation?

Shai_E — Mon, 04 Mar 2024 10:30:28 GMT

Hi @FH1620 ,

Doing a quick search it doesn't seem to me like there is a way to do this.
You will need to use "Open File" block to prep it for reading, but the connectors that you can choose from do not include Qlik Cloud.

You would then need to use "Read Data From File" block.

There is a block to get info on the data files that you have from Qlik Cloud Services, but its just information.

@AfeefaTk Am i missing something here?

Re: How to read a csv file from data-files within an Automation?

cotiso_hanganu — Mon, 04 Mar 2024 14:00:36 GMT

Haven't tried, but I believe a workaround might be possible:
1. first create a Qlik Sense app that reads the csv with qlik script and present it in the interface in a table visualization
2. create a automation that
a. reload the app created before
b. for each row in the table, do whatever you need to do in Automation

Sempre fi, C

Re: How to read a csv file from data-files within an Automation?

FH1620 — Tue, 05 Mar 2024 07:23:40 GMT

Thank you for your reply! I've already tried this attempt, and it actually works. But I'm not sure whether the SheetId and the ObjectId stays the same after exporting/importing to other users...