We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Data Extraction from DB -- to create multiple Worksheets along with respecting Tabs

ll98
9 - Comet

I extracted a file but I want to break that file into individual workbooks . Each workbook with have its own corresponding sheets/Tabs.  For example if Fund x has 7 managers -- I would like to see the workbooks for Fund 1 -- With a Tab for Fund 1 and manger 1005 1006 1007 -- a total of 4 tabs

FundManager
11005
11006
11007
22154
22155
22166
3879
3990

and than another workbook file for fund 2 and so forth.....

 

 

4 REPLIES 4
Qiu
21 - Polaris
21 - Polaris

@ll98 
Is something like this?

0206-II98.PNG

ll98
9 - Comet

I'll give a try.  Thanks 

ll98
9 - Comet

Similar to creating creating multiple workbooks based on Fund -- its possible to create individual Folder based on the Fund name.....

Qiu
21 - Polaris
21 - Polaris

@ll98 

I think it is possible with a Run Command Tool inside a batch macro.

Labels
Top Solution Authors