In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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