Forum Discussion
Solved
First and Last Name Order
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.
Easy enough
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUfLIr0wtUggoKk0FcgwNlGJ1opWMgEyQiAJYEsgxgogbA5kh+bkKiXkpCl6pRUWVQL4xRMoEyAQLgSWBioB8E4iUKbotphBxM7gWR7gWM6BULAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Sales SN" = _t, Name = _t, Qty = _t]), #"Cleansed Names" = Table.AddColumn(Source, "Cleansed Name", each Text.Combine(List.Sort(Text.Split(Text.Proper([Name]), " ")), " ")) in #"Cleansed Names"
2 Replies
Hi, I am not sure if I understood your question correctly, but one of ways to add [Reorder Name] column is doing this in Power Query Editor.
Please check the below picture and the attached pbix file.Easy enough
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUfLIr0wtUggoKk0FcgwNlGJ1opWMgEyQiAJYEsgxgogbA5kh+bkKiXkpCl6pRUWVQL4xRMoEyAQLgSWBioB8E4iUKbotphBxM7gWR7gWM6BULAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Sales SN" = _t, Name = _t, Qty = _t]), #"Cleansed Names" = Table.AddColumn(Source, "Cleansed Name", each Text.Combine(List.Sort(Text.Split(Text.Proper([Name]), " ")), " ")) in #"Cleansed Names"
