Alteryx Designer Desktop Discussions

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

Filtering one and two series only

SH_94
11 - Bolide

Dear community,

 

I would like to ask how can we filter for the following numbers so that the result will be as follow:

Criteria - Filtering only the number start with 1 and 2 only from the input below.

 

SH_94_0-1643351673214.png

Thank you and hope to hear from you soon.

 

 

1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @SH_94 

 

use formula like below in filter tool.

 

 

StartsWith([Field3], "1") OR
StartsWith([Field3], "2")

 

 

Workflow:

atcodedog05_0-1643352049759.png

 

Hope this helps : )

Labels