Forum Discussion

PowerBI_Novice's avatar
PowerBI_Novice
New Member
7 years ago
Solved

Cleaning Free Text

Hi, 

 

I've got a column of data that pulls from a free text field that is meant to capture an agency name. There are some entries that do not match and I would like to either group or have a formula to help clean this up. 

 

Example: I want all of the following entries to be converted to "MedStar". The entries are: 

  • MedStar
  • M/S
  • MedStar #33
  • MS
  • Med Star

There are other agnecy names as well that need to be cleaned up, but not nearly as many. Is this possible? 

 

Thanks! 

Need Help
Show and Tell

2 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

    Use Fuzzy Lookup - read here.  The transformation Table step will be important for you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi PowerBI_Novice .

     

    Follow these steps:

    1. Open Query Editor (edit queries)

    2. Select the column you want.

    3. right click --> Replace values.

     

    Hope this works for you.

     

    Thanks,

    Tejaswi