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
20 - Arcturus
20 - Arcturus

@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
20 - Arcturus
20 - Arcturus

@ll98 

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

Labels