Forum Discussion
Query Editor - replace multiple values
Hi Anonymous ,
How about creating a custom column using if else function?
if [initials] = "GB" then "GREG BROWN" else if [initials] = "CD" then "CHARLIE DAVIS" else ""Best Regards,
Jay
Hi,
Create a seperate 2 column table with Initials in the first column and Name in the second column. Then use the Merge tables functionality to bring over Name from this new table into your existing one. From your existing table, you may then remove the Initials column.
Hi Ashish_Mathur This implies setting up a standalone table.
I am changing the initials, which are part of our ERP system's input. User's select the "Taken By" column and choose from a drop down to select their initials.
By changing the values in this column from initials, to full name, I can make sure the original column from the data source is updated. I don't really want to use a standalone table.
Anonymous - Wait, what do you mean updating the original data source? Using Ashish_Mathur method you can remove and rename columns and such to make things like the original Source data.
Maybe I'm not clear on what you are trying to achieve exactly but Ashish_Mathur said exactly what I would have said.
