Merging Data from two files and validating

[merypals]

Hi all, 

I'm new to Alteryx. I want to do the following: take football club names from the first file and join it with city and population from the second file. Then I want to validate to make sure that all matches are correct. ]

I've given sample examples in the two files I attach. Your ideas are greatly appreciated. 

[oneillp111]

Did you try to use a find and replace tool and match any part of the field?

[oneillp111]

[merypals]

Yes, but not all football clubs have cities listed in their names, so it doesn't work for all records. 

[oneillp111]

In order for a join, there has to be some kind unique Identifier to link the data together.  You could try City code from fc_club file and get city code into the cities file and do a join or F/R on that?