Alteryx Designer Desktop Discussions

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

Filter tool expression

ALLSEBS01
7 - Meteor

Hi all, 

 

I have got a filter tool in my workflow as I'd like to remove any Data that starts with C/33/005890, however the code could be something like C/33/005890/01 or even C/33/005890/04/2 etc.

 

I have tried putting a " * " in after C/33/005890* and have also tried C/33/005890/* and C/33/005890.* - but it isn't working. 

 

I've attached a copy of the configuation of the filter tool, if anybody knows how to remove any variant of C/33/005890.

 

TIA

Filter tool.PNG

1 REPLY 1
alexnajm
17 - Castor
17 - Castor

I would use the StartsWith function!

 

!StartsWith([Projektelm],'C/33/00590')

Labels