Forum Discussion
Check if 2 not sorted string contain the same data
I have a problem I want to check if 1 string is the same than another but in a diferent order in a table measure Example: string1= Jupiter,mercury string2= mercury,Jupiter and return "yes" if...
Hi Anonymous ,
This is my test data.
Adding a custom column in the power query editor.
= if Text.Combine(List.Sort(Text.Split([String1], ",")), ",") = Text.Combine(List.Sort(Text.Split([String2], ",")), ",") then "yes" else "no"Then the result is as follows.
If I have misunderstood you please clarify in a follow up reply.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
This is my test data.
Adding a custom column in the power query editor.
= if Text.Combine(List.Sort(Text.Split([String1], ",")), ",") = Text.Combine(List.Sort(Text.Split([String2], ",")), ",") then "yes" else "no"Then the result is as follows.
If I have misunderstood you please clarify in a follow up reply.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.