Output File - Creating New Output files all the time

[akumar2609]

I have a workflow which create Data contain a column name “Type of Scenario” which has scenario 1, scenario 2, scenario 3 and so on. I want the data to be pasted in pre-existing template (Depreciation File) from cell A6 to Z200. What I need Alteryx to do here is to paste the data based on the Type of Scenario column. For example:-

Output File 1 - Depreciation File should contain all the data for scenario 1.
Output File 2 - Depreciation File should contain all the data for scenario 2.
Output File 3 - Depreciation File should contain all the data for scenario 3.

And this should go on for all the scenario which we have for the current month. Incase we have 2 scenarios, we should have two output file and incase we 5 scenario, I need 5 output files.

Please help.

[EKasminsky]

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Output-Excel-with-Dynamic-File...

This solution should have what you are looking for.