How to use Filter tool

[suspang]

Hi,

I am new user to Alteryx Designer, and have the question regarding the Filter tool. How to use this tool to remove any states that begin with the letter "M"?  Any suggestion?

[JagdeeshN · Accepted solution]

@suspang 

Please find attached a sample workflow.

Specifically you would need to use the following condition:-

Left([Field1], 1)="M"

Do let me know if this helps

Best,

Jagdeesh

[AngelosPachis · Accepted solution]

Hi @suspang ,

You can use a custom filter using an embedded function called Startswith. The expression should be:

Startswith([State/Jurisdiction],"M")

That will cause all records where state begins with an "M" to fall out of the True output anchor of the filter tool, whilst the rest will fall out of the False output anchor.

Hope that helps.

Cheers,

Angelos