Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Merging Data from two files and validating

merypals
6 - Meteoroid
‎06-26-2023 04:15 AM

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. 

Preview file
7 KB
Preview file
7 KB
Labels:
Reply
0 Likes
4 REPLIES 4
oneillp111
9 - Comet
‎06-26-2023 06:42 AM

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

Reply
oneillp111
9 - Comet
‎06-26-2023 06:47 AM

example.xlsx.png

Reply
merypals
6 - Meteoroid
‎06-26-2023 07:11 AM

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

Reply
0 Likes
oneillp111
9 - Comet
‎06-26-2023 07:21 AM

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?

Reply
go to user group event calendar
Labels