Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Output File - Creating New Output files all the time

akumar2609
8 - Asteroid

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.

1 REPLY 1
EKasminsky
8 - Asteroid
Labels
Top Solution Authors