Alteryx Designer Desktop Discussions

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

Data Output to Multiple Excel Workbook

ll98
9 - Comet
Fund NameCommitments
Fund 150000
Fund 245000
Fund 340000
Fund 4100000

 

I'm having creating a separate file based on Fund.  Hence, I need to create a file/workbook for each of Fund.  I also want to name the tab the Fund Name

3 REPLIES 3
grazitti_sapna
17 - Castor

Hi @ll98 

Try this, you will have to create a formula to specify file name and sheet name as mentioned below.

 

grazitti_sapna_2-1613624348393.png

 

Use this config to output data into multiple excel files.

 

grazitti_sapna_1-1613624319107.png

 

Output.

grazitti_sapna_3-1613624398812.png

 

 

grazitti_sapna_0-1613624290471.png

 

If this works kindly mark this post as solution.

Thanks.

 

Sapna Gupta
ll98
9 - Comet

Thanks Sapna .. But the tab name -  I want to see the actual Fund Name ... i.,e Fund 1  

smoskowitz
12 - Quasar

If you choose the Fund Name column, the tabs will be named by each fund. Are you finding this to not be the case? You will need to choose 

 

smoskowitz_0-1613676674643.png

 

Thanks,

Seth

Labels