Forum Discussion
PowerBI Merge queries not matching correctly on mixed format IDs
I am trying to merge two tables in PowerBI, the IDs have two formats: 7 numbers or 2 numbers-2 letters-2 numbers, I have attached a preview below. When merging the queries (left outer) it matches the...
In Power Query on the data samples that do not match, do a character by character comparison looking at the ASCII codes to see if they match. Or post something here that can be used to reproduce your problem.
List.Transform(Text.ToList([Column1]), each Character.ToNumber(_)) = List.Transform(Text.ToList([Column2]), each Character.ToNumber(_))
ronrsnfld
Super User
Super UserIn Power Query on the data samples that do not match, do a character by character comparison looking at the ASCII codes to see if they match. Or post something here that can be used to reproduce your problem.
List.Transform(Text.ToList([Column1]), each Character.ToNumber(_)) = List.Transform(Text.ToList([Column2]), each Character.ToNumber(_))