Dynamic Outputting

[Hamza199]

Hi,

I am relatively new to alteryx and am struggling to understand the concept of dynamic outputting.

Currently, I have a file with 10 tabs/worksheets. I have created a workflow per worksheet as each worksheet requires different analysis. Then, I output all worksheets to the same xlsx file and manually input the sheet name in the option when selecting output data. However, this can become quite manual when having to do it 10 times every week. 

I would like the sheet name to be the same as what it is when it is originally inputted. Therefore, I assume that there must be some way to tell alteryx to output this worksheet with the same name as sheet inputted.

Could someone please helps?

Thanks in advance!

[binuacs · Accepted solution]

@Hamza199  the below post will be useful for your use case

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-output-multiple-tabs-within-a-s...

[OllieClarke · Accepted solution]

Hey @Hamza199 

You can input the filename and sheet name of an excel by choosing the 'full path' value in option 5:

This will give you the fullpath of the file and sheet as a field in your stream:

When you output your data, at the bottom of the output data tool there are these options:

Which if you set them up as here, will output data to the specified fullpath (i.e. filename and sheetname) from the full path field, but not include that field in the output (unticking that box). 

Hope that helps,

Ollie

[Hamza199]

Hi,

Thank you, it worked! 

Hamza