Forum Discussion
Replace/Translate UserID's into UserNames
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.
I did merge those two sources into one , but new columns have been generated , but i am looking for replacing/converting the already existing UserID values into Username from my second source where it matches.
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.
Thanks lbendlin ,
i treid this and it worked
but in my main report i see some records as below
AAA0000 | BBB0000 (in the same cell)
at these places i'm getting null in UserName column
i have a work around by hard coding these values in my second datasource and map them , but
how i can do with out that, by some delimiter ignorance or some thing like that ?
Add a step where you split columns by pipe ("|") and throw away anything but the first value?
Or maybe improve the quality of your source data.
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