Approximate Match Between Columns

[Reade39]

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 1	Column 2
Welwyn Garden City	Luton Airport
SOUTHAMPTON AIRPORT	Southampton Airport
Inverness	Inverness Airport
Great Yarmouth	Norwich Airport
St Albans Regus Victoria Sq	London Victoria
Bathgate	Castleford

I would like to output to look like this: 

Column 1	Column 2	Column 3
Welwyn Garden City	Luton Airport
SOUTHAMPTON AIRPORT	Southampton Airport	Southampton Airport
Inverness	Inverness Airport	Inverness
Great Yarmouth	Norwich Airport
St Albans Regus Victoria Sq	London Victoria	Victoria
Bathgate	Castleford

[Felipe_Ribeir0]

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

[binuacs]

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

[Felipe_Ribeir0]

Hi @Reade39 

It worked?