Can we read and Write on CSV/Excel/Txt file stored on Specific Space Data Files in Automation in Qlik Cloud

[harshal_shreyesh]

Hello,

Is there a possibility to read and write on file stored on Data files of Specific space ? I would like to read those in my Automation and write something in it and store back on same space. 

[JandreKillianRIC]

Hi @harshal_shreyesh 

Can you perhaps share the use case? Maybe not the actual use case but a similar example?

I know in On prem we can do this without using automations so just trying to get the bast possible solution for you. 

Regards Jandre 

[harshal_shreyesh]

Hello @JandreKillianRIC ,

Thanks for taking out time for this. I have below use case ,

1. There are several QVD generator scripts in Qlik cloud
2. I would create a Automation to reload those Scripts one after another in single automation
3. So to pass APP IDs in each 'DO Reload' block i would like to read it from CSV/TXT etc. file within Automation 
4. Pass the App IDs from csv/txt file to each reload block or Loop over each APP ID and reload

This way I can modify the CSV/txt file with app IDs and Automation would reload those.

[JandreKillianRIC · Accepted solution]

Hi @harshal_shreyesh 

For some reason I cant get the list data files block to work for a space other than the personal space. 

My quick workaround > Upload the excel file into a space, add it to an application and create a table that will list the ID's. See below 

On the automation, Add the following blocks 

Point this block to the application, sheet and object.

I have also uploaded the quick test I build. You can import this when creating a blank automation.

Just right click in the automation window, Upload Workspace 

Let me know if this would work for you. 

Regards Jandre

[harshal_shreyesh]

Thanks a lot @JandreKillianRIC . This works for me now.