Free Trial

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
Top Solution Authors