Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.