Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a column containing first and last names but the order is not consistant, sometimes the order is Last Name First Name and sometimes the order is Fist Name Last Name (eg. Hoyer Prue and Prue Hoyer)
I am hoping to find a way to combine the data for Hoyer Prue and Prue Hoyer as they are the same person.
Solved! Go to Solution.
=Text.Combine(List.Sort(Text.Split([Name]," "))," ")
this can help to find the duplicated names, but it can no recognise which is the first unless you have a supporting list of first name or last name.
you can split the name by space, then List.Sort and Text.Combine
How would that help if you're not finding a way to identify which is first and which is second?
The split gives
Hoyer Prue | Hoyer | Prue |
Prue Hoyer | Prue | Hoyer |
Then combining
Hoyer Prue | Hoyer Prue |
Prue Hoyer | Prue Hoyer |
=Text.Combine(List.Sort(Text.Split([Name]," "))," ")
this can help to find the duplicated names, but it can no recognise which is the first unless you have a supporting list of first name or last name.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.