Save File Outputs to Different File Path Locations

Question

Hello!

I have a data set with a Division Code Field. I subsequently need to output a separate files for each Division and have each saved to the Divisions' respective folder on a shared drive. I have a Reporting Paths file (screenshot 2 below) that dictates each file path location by Division Code (i.e. where it should be saved). How could I use the Reporting Path file by Division to have Alteryx save each Division file to its respective folder (i.e. file path)?

Screenshot 1 -

Screenshot 2 - File Paths by Division

Thanks!

AnaSofiaPires · Answer

Hello @RolandSchubert  , could you share the Macro?

How did you built it ?

I am trying to save multiple PDF outputs from a render tool, into a new folder each quarter, but I dont know how to automatically change the «location

RolandSchubert · Answer

Hi @jbfries ,

an approach could be to move the "output part" to a batch macro and hand over the respective chunks of data. I've adjusted your workflow a bit.

The reporting path file included in the package is tailored to my environment, so you have to replace it.

Best,

Roland

Workflow Sample modified.yxzp

jbfries · Answer

Hi Roland,

Thank you for your help!

Attached is my current workflow. Had to remove sensitive data from the Paths and Report. I was able to output to different file paths using the output tool, but couple questions below.

2 Questions:

1. Can I do the same as your screenshotted workflow, but using a Render tool? I would like to be able to format the output and have not found a way to do that using the Output tool.

2. Is there a way to specify the sheet name in my Formula Tool #15 to be the 'FileName' field from the data?

Thanks again!

Workflow Sample.yxzp