Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Output multiple sources (excel file and its tab)

DannisMen
8 - Asteroid

Hi

 

I wonder if there is any ways to output by two columns into excel. 

 

For example, Column A is used for each excel file and Column B is used for each tab within that excel. 

 

Column A: a, b

Column B: c, d

 

Result would be two outputs: a and b. Both of them have tab c and d. 

 

Is it possible to do in one workflow?

4 REPLIES 4
Emil_Kos
17 - Castor
17 - Castor

Hi @DannisMen,

 

Please check this workflow.

 

If this helped you with your problem please mark as solved!

 

If I understood your question correctly this workflow will guide you how to achieve it!

DannisMen
8 - Asteroid

Hi,

 

Thanks for your response but it's not quite what i want. 

 

Attached is my question that represents in a workflow. At this point, it can only output to 1 excel file and three tabs (111,222,333). Is there a way to output to different FILES by (AAA, BBB, CCC). 

 

Thanks

DannisMen
8 - Asteroid

Forgot to attach

AkimasaKajitani
17 - Castor
17 - Castor

I make sample WF.

Firstly you make a file path by two fields and specifying it.

 

AkimasaKajitani_1-1603844543603.png

 

AkimasaKajitani_2-1603844559008.png

 

 

AkimasaKajitani_0-1603844520184.png

 

Labels