Customize Filter

[itssreeji]

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

[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

[binuacs · Accepted solution]

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

String Functions | Alteryx Help