Customize Filter

Hi All,

Need your expertise help. I have a input header which is a 5 character alpha numeric number and want to create a customize filter which is "Begins with" first two character, example 1B. which would limit my input data for further analysis.

Thanks

Sreejith

Help

Accepted answers

binu_acs

@itssreeji the string function StartsWith will be helpful for your use case

String Functions | Alteryx Help

Filter_08_07.yxmd

All comments

Amol_Telore

can you provide some sample data?

CharlieS

Do you want to filter the records based on data values, or fields based on the name> There's options for both.

If you want to filter records where data values in a [Field], then you can use a Filter tool with a custom expression for that that looks like this:
Left([Field],2)='1B'

Where the left two characters of the field value are "1B"

If it's the fields you want to select/deselect, you can use a Dynamic Select tool with a similar formula.

Let us know if this makes sense and we can go from there.

itssreeji

Including the sample

Sample.xlsx

binu_acs

@itssreeji the string function StartsWith will be helpful for your use case

String Functions | Alteryx Help

Filter_08_07.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703