Forum Discussion

Babinsky's avatar
Babinsky
Icon for Helper I rankHelper I
9 years ago
Solved

Adding a new value in an Existing field

Hi All,  I have a question:    I have 2 fields Code - which contains - 6980 Cause - which contains -  ABC  I'm looking to use Advanced Editor to populate the field Cause with value ZWR if Code =...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    Babinsky

    I think Greg_Deckler refers to add a "custom column" in "Query editor" window "add Column" tab.

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

There's probably some fancy M for that, but brute force, create a new conditional column,

 

= if [Code] = 6980 then "ZWR" else [Cause]

Remove your original Cause column and rename this column to Cause and done.

LaurentCouartou's avatar
LaurentCouartou
Icon for Solution Supplier rankSolution Supplier
9 years ago

Also, you can use the Add Conditional Column feature for that kind of calculations.