Approximate Match Between Columns

Question

Hi all - I am cleaning address data and need to make a comparison between the values in two columns. I'm not sure how to achieve this but I would like to see if any text is shared between cells. I would then like the common value to be output into a new column. I've attached a sample. Thanks in advance!

Here is the data:

Column 1Column 2Welwyn Garden CityLuton AirportSOUTHAMPTON AIRPORTSouthampton AirportInvernessInverness AirportGreat YarmouthNorwich AirportSt Albans Regus Victoria SqLondon VictoriaBathgateCastleford

I would like to output to look like this:

Column 1Column 2Column 3Welwyn Garden CityLuton Airport SOUTHAMPTON AIRPORTSouthampton AirportSouthampton AirportInvernessInverness AirportInvernessGreat YarmouthNorwich Airport St Albans Regus Victoria SqLondon VictoriaVictoriaBathgateCastleford

Common Address Sample.xlsx

Felipe_Ribeir0 · Answer

Hi @Reade39

It worked?

binu_acs · Answer

@Reade39 One way of doing this with the fuzzy match tool

Fuzzy_Match_011923.yxmd

Felipe_Ribeir0 · Answer

Hi @Reade39

One way of doing this

Another way would be by using fuzzy match: https://community.alteryx.com/t5/Alteryx-Use-Cases/Fuzzy-Match-Check-Row-by-Row/ta-p/270809

parsecolumn.yxmd