Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Query Editor - replace multiple values

Hello -  Our ERP system captures input for who took an order....but the input is the person's initials.     I have about 40 of these two change....but don't want a giant list of "Replaced Value" in...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.  

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

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.