Join the Inspire AMA with Joshua Burkhow, March 31-April 4. Ask, share, and connect with the Alteryx community!

Alteryx Designer Desktop Discussions

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

Have separate output file

ardbramantyo
5 - Atom

Screenshot_20231117_131228_Microsoft 365 (Office).jpg

 hi, i have this dataset and I want to have several excel file as output with filename is the campaign name. In the output file I want to have 3 worksheet. Sheet one for overall data, sheet 2 for list thay have value SMS from flag column and one sheet called WA for overall list that have WA value in the flag column. In my original dataset I have total of 12 campaign name so I will have 12 excel files at the end and for every file I will have e worksheets. For overall, WA, and SMS sheet

5 REPLIES 5
gawa
16 - Nebula
16 - Nebula

@ardbramantyo 

 

You can use option of Output tool "Take File/Filed Name From Field" to create separate outputs,

 

image.png

 

For example, you can create file path by Formula tool like this. Please specify sheet name after "|||".

image.png

ardbramantyo
5 - Atom

What if I want to have 3 worksheet in my every generated files that taken from my Flag column? I want to have WA sheet and SMS sheet based on criteria

Qiu
21 - Polaris
21 - Polaris

@ardbramantyo 
I think we may need to a Batch Macro for this task.
For each Campaign code, we will process your requirement in the macro.

1117-ardbramantyo-A.PNG1117-ardbramantyo-B.PNG

ardbramantyo
5 - Atom

Thanks :)

ardbramantyo
5 - Atom

Why I also have .bak file in my output?

Labels
Top Solution Authors