Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
FH1620
Contributor
Contributor

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

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

Labels (1)
1 Solution

Accepted Solutions
cotiso_hanganu
Partner - Creator III
Partner - Creator III

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

View solution in original post

3 Replies
Shai_E
Support
Support

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?

cotiso_hanganu
Partner - Creator III
Partner - Creator III

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

FH1620
Contributor
Contributor
Author

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...