Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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