Dear Community,
I would like to ask if we can match the two data below into one data:
May i know if this is possible done in the alteryx?
Hi @SH_94
It took sometime. Here is how you can do it. Fuzzy match
Workflow:
1. Using formula tool I am converting all last name, first name formats to first name last name.
2. Using data cleanse tool to remove duplicate spaces and convert all to upper case.
3. Using fuzzy match to match the columns.
4. Using unique tool to get unique match rows.
5. Setting ID for matches
6. Tranposing match column to rows with ID as key.
7. Using find & replace to ID to the name.
8. Using ID to map 2 data sources.
Hope this helps 🙂
Dear @atcodedog05 ,
This is really smart application . I would like to clarify with you on the following concept:
1. Could you briefly explain the concept for the formula - REGEX_Replace([Employee name], "(.+),(.+)", "$2 $1") ? Why we need the $2 and @$ 1?
2. Would there be any impact if we choose lower case for step 2? Why we need to change it all to Upper case in this case?
3. For the Matchscore and MatchScore_format , normally how many percentage is acceptable ? ie more than 90% ? as i can see the threshold set is 80%. Based on your experience, may i know whether the 80% safe enough?
4. Could you briefly explain how is the following screenshot work? As in how do we know which one to choose for the field name?
5. May i know what is the difference between U and D in this case?
many thanks for your help.
In my scenario i am creating a new column hence i am allowed to change data type and size. Since you are using formula on existing column data type option is frozen. To can use select tool before formula tool to set the desired datatype size or create a new column.
Thanks a lot for the guidance and it works. May i know what are these two functions under the find and replace tools?
Thank you.
