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?
Formula tool configuration below
Output tool configuration below
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
Solved! Go to Solution.
@Mike_at_CG
I agree with you.
Lets change the option for output as below first?
Yep. That totally did it. Thanks for the help and the lightening fast response. Have a good night!
@Mike_at_CG
Glad to help and you too have a good one.