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

Equivalent of an excel "if & match"

GSingh
5 - Atom

Hello All - New user, not sure the best way to do the below, have tried join, merge but not getting very far...

 

I have 2 CSV files.  The first file has all my data.  The second file has 1 tab with a list in column A.

What would be the best way for me to import the 2 files and then do the equivalent  of an excel "if & match" function.

i.e. if a cell in column A from file 1 matches any cell from the list in file 2 column A (tab 1) then return a specific name (Say "Identified") in file 1 (say column D)

Hopefully hat makes sense

 

Thanks

 

3 REPLIES 3
MarqueeCrew
20 - Arcturus
20 - Arcturus
You can use a find and replace tool. The reference data would be input to the bottom anchor. Append the lookup value. If that value is null after the lookup, it isn't present. Otherwise it was a match.

https://help.alteryx.com/10.6/index.htm#FindReplace.htm?Highlight=Find%20replace
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
GSingh
5 - Atom

That is works really well.  Within the Find and Replace tool anyway I can get the appended column to display a certain text when it matches? or do I need to do this through the formula tool?

 

Thanks again.

 

 

MarqueeCrew
20 - Arcturus
20 - Arcturus

IIF(IsNull([Appended_Fieldname],"No Match", "Match")

 

Yes, a formula with an expression like the one above will do the trick.  You'll then want to have a select to de-select the appended column.

 

Happy Turkey,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels