Report Automation with SFTP

Spartan27215 — Thu, 22 Jun 2023 14:44:17 GMT

How can I control a report output automation to do the following.

1. Loop through a table and use each row in this table to set as an app filter.

2. for each row in this table create a report that contains data with that filter applied.

3. Write that report to an SFTP site and set the Filename to the Date and Filter value used in 1.

Re: Report Automation with SFTP

Spartan27215 — Thu, 22 Jun 2023 20:42:37 GMT

Well, I sort of figured it out in a really round about way.

Well it took me half of a the day to figure something out.
1. I had to manually create a managed space, I named it Monthly Report Temp
2. I had to use loop and reduce to publish an app to that space using the name monthlyreport.
3 I then modified the automation to add create report, generate report, and SFTP Copy file.
3. I had to set the create report App id to the one I created in #2 above i.e. "monthlyreport"
4. I then used the Loop and reduce Value to set the value of my filename.

Now I need to figure out how to get the current date to use in the file name.

topic Report Automation with SFTP in Qlik Automate

Report Automation with SFTP

Re: Report Automation with SFTP