Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Bengaluru, IN

Welcome to the Bengaluru User Group

Click in the JOIN GROUP button in Home to follow our news and attend our events!

SOLVED

!Contain (doesn't contain)

Neeta_Latwal
7 - Meteor

Hi All,

 

We have one column where more than 200 type of currency are populated but I want the data excluidng 6-7 currency what function can use, please help.

 

I was using !contains("USD" + "INR" + "GBP" + "abd" + "DEF") but this function is not woking.

 

Thanks,

Neeta

4 REPLIES 4
SangeetaDoni
5 - Atom

You have use filter tool with "doesn't contain" and syntax  instead of  !contains("USD" + "INR" + "GBP" + "abd" + "DEF")  could be !Contains([column name],"USD") and !Contains([column name],"INR") and !Contains([column name],"GBP") and !Contains([column name],"GBP") 

Use Filter tool :
Expression :  [Input_field_name] NOT IN ('USD' , 'INR' , 'GBP' , 'abd' , 'DEF')

Neeta_Latwal
7 - Meteor

Thankyou Sangeeta & Kapil for your quick response

Its really helpful.

shashanksaie28
5 - Atom

Additionally to the above you can also use 'Select Records' tool if these currency codes always appear at a particular record number. You can mention their respective record numbers (row numbers) in the Configuration options of the Select Records Tool to exclude them.