Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to use Filter tool

suspang
5 - Atom

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?

 

suspang_0-1611861329497.png

 

2 REPLIES 2
JagdeeshN
12 - Quasar
12 - Quasar

@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
16 - Nebula

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 

Labels
Top Solution Authors