Split Data into Different Workbooks by Letter
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Mike_at_CG
I agree with you.
Lets change the option for output as below first?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yep. That totally did it. Thanks for the help and the lightening fast response. Have a good night!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Mike_at_CG
Glad to help and you too have a good one.
