how do I pull multiple values from one column of data?

[Lin_dup_192]

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.

[Lin_dup_192 · Accepted solution]

Never mind.   I figured it out.  Sorry.

[kelsey_kincaid]

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.

[kelsey_kincaid]

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.

[Lin_dup_192]

@kelsey_kincaid,

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.