Alteryx Designer Desktop Discussions

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

How do I select lines starting with specific number

Aamir651
6 - Meteoroid

How do I select lines starting with specific number from a data on workflow, say all numbers starting from "01", "02", "03"

1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @Aamir651 

 

Two ways you can do this

 

1st way: using startswith() function

atcodedog05_1-1634982593683.png

 

2nd way: using find and replace tool matching begins with 

atcodedog05_2-1634982636674.png

 

Hope this helps : )

Labels