Report Automation with SFTP

[Spartan27215]

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.

[Spartan27215 · Accepted solution]

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.