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 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