Alteryx Designer Desktop Discussions

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

Output multiple files and multiple sheets.

Ferdy
6 - Meteoroid

 

Hi,

 

I know how to generate one file to multiple excel files

and how to generate one file to multiple sheets in one excel file.

but, I don't know how to generate one file to multiple excel files and sheets.

 

please refer to attached the image.(this is the result screen I want)

multiple_files_and_sheets.png

I want to split file names by "month" and sheets by "name" 

 

I appreciate everyone's help

Thanks

 

7 REPLIES 7
afv2688
16 - Nebula
16 - Nebula

Hello @Ferdy ,

 

Try this:

 

Untitled.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Ferdy
6 - Meteoroid

@afv2688 , Thank you for your help.

 

I thought it too hard... 😞

Your solution is very simple and nice.

 

Thank you again!

afv2688
16 - Nebula
16 - Nebula

You are welcome1

royshubhadeep
5 - Atom

Hi, can you please share the workflow again? The one here seems to be incomplete. I am trying to split the output to multiple sheets within a same workbook based on a column/field in the output.

royshubhadeep
5 - Atom

No worries. I found the solution.

suby
11 - Bolide

Thanks can you please re upload completed workflow.

 

Thaks,

royshubhadeep
5 - Atom

Split output into multiple excel sheets within the same workbook based on a column value.

Labels