Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Replace/Translate UserID's into UserNames

1) I have imported a database table into Power BI , and it contains "UserID" values 2) I have exernal CSV file that contains UserID and UserName columns  3) Now, i would like to replace/translate  ...
Need Help
  • lbendlin's avatar
    lbendlin
    6 years ago

    you can do all that in Power Query. Either replace the value in the existing column with the value of the merged column and then remove the merged column, or remove the existing column and rename the merged column to the name of the original column. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yes i did , it splitting the column into new one and values gets seperated , but i am here tryting to convert those ID's into names as it is with the "|" (pipe) seperated as below 

 

UserID                                UserName 

AAA000 | BBB000              Alice | Bob 

 

 

lbendlin's avatar
lbendlin
Super User
6 years ago

Just say NO to bad data?