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.
Hi!
I have a tedious problem with some "raw" data here. I have a list of companies names with several differents names for a same companie i.e. A companie named "Muebles S.A." can be found with the following names : "Muebles S.A." , "muebles s.a." , "Muebles SA." , "MueblesSA." etc. I mean it is the same name but with more spaces beetwen words or a dot at the end or withouth dots in the word so BI understand the name like different even when it is not.
So... is there a way to use the Query Editor to transform the list and try to unify the names? Or as a plan B is there another software that could do that?
Thanks for your help. Have a nice day.
Alejandro
Solved! Go to Solution.
So, yes, you can replace values in Query Editor, do things like Trim, Clean, Capitalize, etc. Just right click the column in Query Editor and choose Transform for many of these. For the specific case below, if you did a "Capitalize Each Word" and replace "." with "" and spaces with "" then you should get them all into "MueblesSA"
So, yes, you can replace values in Query Editor, do things like Trim, Clean, Capitalize, etc. Just right click the column in Query Editor and choose Transform for many of these. For the specific case below, if you did a "Capitalize Each Word" and replace "." with "" and spaces with "" then you should get them all into "MueblesSA"
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.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |