Alteryx Designer Desktop Discussions

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

Removing data Assisstance?

SahilArora3139
8 - Asteroid

hi all

can someone help me what should be done for this situation:

 

s.no.    Name   Address

1.         A$.      NY

2.         A.         UK

3.         C$.       CA

 

i want to remove the data having dollar($) in Name column.

 

output should be:

 

2.    A.     UK

 

others two should not be there as it have dollar sign in Name column .

 

please help

4 REPLIES 4
binuacs
21 - Polaris

@SahilArora3139 In the filter tool add the condition

!Contains([Name],'$')

SahilArora3139
8 - Asteroid

thank you so much

SahilArora3139
8 - Asteroid

Just one small thing, if i want to segregate pattern having $ sign at the end only then it will work the same?

 

like

A$
$A 

A

so $A is acceptable andhence  A and $A should be the output

only the name having dollr in end needs to be excluded 

binuacs
21 - Polaris

@SahilArora3139 In that case use the !EndWith() function in the filter tool

 

image.png

 

Labels
Top Solution Authors