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

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.

Book1.xlsx

Output

Accepted answers

Lin_dup_192

Never mind. I figured it out. Sorry.

All comments

Lin_dup_192

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.

MultipleValuesOneColumn.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703