Forum Discussion

AlejandroPCar's avatar
AlejandroPCar
Helper IV
8 years ago
Solved

Data Wrangling with Query Editor

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

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    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"

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    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"