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

 

Thanks!

 - Babinsky

Need Help

5 Replies

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

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

      Hi Smoupre, for your suggestion below would this be a New Measure, New Column?

       

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

       

      Thanks!

       

      - Babinsky