Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Comparing two columns to see if any Text in Column A matches Column B

Masond3
8 - Asteroid

HI All 

Long time 

I need some assistance 

 

Aim : Per row to validate if the name in column "Name b" is found within column "Name A"

 

 

I wrote the following formula "if contains([Name B],[Name A]") then "Contains" else "No Match" endif" however i am presented with an "Mal informed" error 

 

Example 

Name AName BOutcome 
Mason LTDFairstone Financial Management LtdNo Match
PI LtdCountrywide No Match
Intelligent Money LtdIntelligent MoneyContains
Alpha To Omega (UK) Limited - In LiquidationCyrptoNo Match
Raymond James Investment Services LtdCyrptoNo Match
SW Funding plcCyrptoNo Match
Schroders Wealth & Investment SchrodersContains
Funky House Financial Fitness LtdFunky House Fitness LimitedContains
HSBC- W&IM - UKHSBCContains
Ironmarket LtdBoolersNo Match
David Booler & CoBoolersContains
Blackstone Moregate LtdAjax Wealth Management LtdNo Match
Cartlidge Morland LtdCartlidge MorlandContains


Looking forward to your assistance

Regards
Masond3

2 REPLIES 2
binuacs
20 - Arcturus

@Masond3 

 

IIF(Contains([Name A], [Name B]), 'Contains', 'No Match')

 

IF Contains([Name A], [Name B]) THEN 'Contains' ELSE 'No Match' ENDIF

binuacs_0-1645523025749.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @Masond3 

 

There is not needed quote here please remove it and it should work

 

atcodedog05_0-1645524462115.png

And formula should be as below similar to as @binuacs mentioned

 

atcodedog05_1-1645524514062.png

 

Hope this helps : )

Labels