Alteryx Designer Desktop Discussions

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

Filter for a string starting with two letters

andrewplaice
8 - Asteroid

Hi there,

 

I need to filter data for account numbers beginning with two letters. Any ideas?

 

Thanks!

4 REPLIES 4
JosephSerpis
17 - Castor
17 - Castor

Hi @andrewplaice I mocked up a workflow let me know what you think?

andrewplaice
8 - Asteroid

Thanks for the quick reply Joseph!  This is close, but it is also picking up account numbers starting with one letter.  In this case, I have to isolate by 2 letters.  Is that possible?

JosephSerpis
17 - Castor
17 - Castor

Hi @andrewplaice I revised the workflow let me know what you think?

andrewplaice
8 - Asteroid

That seems to work perfectly!  Thank you so much!

Labels