Output Tool - 'Dynamic Filename' feature and 'Tab-Split by Values' feature

Hello experts,

I am quite new to Alteryx and am wondering if there are some Alteryxians here willing to share advice and/or ideas.

I am currently trying split records into different tabs by values in excel file as output and am utilizing the feature in Output Tool called "Change File/Table Name". At the same time, I also want to make use of the "Change Entire File Path" to generate dynamic file name. But since Output tool only allows one selection of 'feature', I was wondering if you have any idea/suggestion to circumvent this?

Thank you and would appreciate any kind of ideas.

Workflow

Output

Accepted answers

grazitti_sapna

Hi, @owenkosnen if you are trying to generate two different scenarios such as

1) Separate tabs in a single file.

2) Separate files grouped by a specific field

3) If you are trying to generate different files with tab name same to the file name then you can use this workflow.

I have provided 3 solutions.

Thanks.

ExcelOuput-GS.yxmd

atcodedog05

Hi @owenkosnen

Here is an example

Formulas

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

name-tab.yxmd

All comments

atcodedog05

Hi @owenkosnen

If i understand correctly you want to change filename as well as tab name.

You can write a formula like below.

and load on Change filepath

Workflow:

Check and let me know

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

name-tab.yxmd

Emil_Kos

Hi @owenkosnen

I have prepared a mockup workflow for you

If this was something helpful please mark as a solution!

Dynamic Output.yxmd

grazitti_sapna

Hi, @owenkosnen if you are trying to generate two different scenarios such as

1) Separate tabs in a single file.

2) Separate files grouped by a specific field

3) If you are trying to generate different files with tab name same to the file name then you can use this workflow.

I have provided 3 solutions.

Thanks.

ExcelOuput-GS.yxmd

owenkosnen

@grazitti_sapna Wow - this is very close to what I'd like to achieve.

The key lies in the formula tool where we first setup the dynamic sheetname with formula with the aim to split records into different tabs, and then use the Output Tool to change the filepath based on the Filename generated with Formula.

One question though, I tried your method and it works great for the most part, but it returns error when there is actually no data in the [Country] or any field that will be assigned to be sheetname. Is there a way to ignore the error and let the empty excel be created when there is no data?

atcodedog05

Hi @owenkosnen

My first solution was tailored for your specific requirement. Can i get your feedback on did it fail anywhere or why did not choose to go ahead with it. Would it because of the example taken or the the workflow didn't work as expected.

Your feedback will help me to improve my approach of solution, example taken or anything that will improve the overall experience.

Would really appreciate your feedback.

Happy to help 🙂

Cheers and Happy Analyzing 😀

owenkosnen

Hi @atcodedog05

Sorry if I was being rude, I did acknowledge your approach and really grateful for your effort in helping me solve my problem. I have marked one of your comments as suggested solution.

Thank you very much!

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167