how do I pull multiple values from one column of data?
- 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
Hi, I have a file to large for EXCEL so I need to create outputs from Alteryx breaking it up by Classes. For example, I want all the "471%%" classes as 1 output, all the "472%%" classes as 1 output, etc...I see the Contains function but I don't see how to use it for multiple values.
Thank you in advance
Lin
PS not sure I got the label correct.
Solved! Go to Solution.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Never mind. I figured it out. Sorry.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Lin_dup_192 ,
You could use a formula tool to isolate the first 3 characters in the 'From Class' column, then use that field to change the file name of your output. I've attached a rough example below.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Lin_dup_192 - it always feels good to figure something out after struggling with it for awhile! Would you mind posting your solution? Other people may run in to the same question and benefit from your solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I will post my solution as soon as I get it done. I was going to manually do what you provide and then an IF statement. You just showed my how to do it ALL in Alteryx! Thanks.
