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

Match the column value with another

RanjanKT
8 - Asteroid

Hi All,

 

Can someone help me to resolve this issue.

 

I have 2 columns where i need to search the values from one column with another column if its exists anywhere then it should be true.

For Eg. "Ranjan" from column1 exist anywhere in column2 then the result column should populate as "TRUE"

 

 Match.jpg

2 REPLIES 2
Martyn
9 - Comet

Use a Join with this table being the Left and Right Input but joining on Column1 from Left to Column2 from Right.

Any records in your L output would then be False. Any records in your J output would be True. Ignore anything in your R output.

You can then Union the L and J output.

danilang
19 - Altair
19 - Altair

Hi @RanjanKT 

 

You can also use a Find Replace tool configured like this

 

fr.png

 

Any values from column 1 that has a corresponding value in column 2 will have that value added as column3.  For the values that don't match you'll end up with null.  Add a formula tool, clean up the extra field and you have

 

r.png

 

Dan

 

 

Labels