conditionally update a column's value

Ali
Ali
in Data preparation

in my dataset i have a number column that ranges from 0-100, i want to add a new column with these values

  • 0-15 -> Type A
  • 15-55 -> Type B
  • 55-80 -> Type D
  • 80-100 -> Type D

is it possible to do that in symon ?

Comments

  • AMuresan
    AMuresan

    As always, there are a few ways you can do this (one silly one would involve lots of filters splits and then uniting back together, do not do this), one is the formula tool, but an easier one in my opinion is the case tool:

    image.png

    Here I only defined the first two cases you listed but you get the idea. :)

Categories