Free Trial

Alteryx Designer Desktop Discussions

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

Split Data into Different Workbooks by Letter

Mike_at_CG
8 - Asteroid

Hello Alteryx Community

 

I am trying to split a massive file of Nasdaq tickers into separate workbooks by the first letter of the ticker symbol.  So anything starting with the letter A gets saved into its own workbook and then any starting with letter B gets saved into their own workbook as well.  Eventually making it from A all the way down to Z and at the end I should have 26 separate workbooks.

 

The below workflow saves all the letters to separate worksheets within the same workbook. Is it possible to send these to a completely separate workbook by letter?

 

Mike_at_CG_0-1665096750490.png

 

Formula tool configuration below

Mike_at_CG_1-1665096905368.png

 

Output tool configuration below

Mike_at_CG_2-1665096953468.png

 

Still a newb so I am sure there is something I'm easily tripping over.  Any help is greatly appreciated.  Thank you for your time

 

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@Mike_at_CG 
I agree with you.
Lets change the option for output as below first?

a.png

Mike_at_CG
8 - Asteroid

Yep. That totally did it. Thanks for the help and the lightening fast response. Have a good night!

Qiu
21 - Polaris
21 - Polaris

@Mike_at_CG 
Glad to help and you too have a good one.

Labels
Top Solution Authors