Column expression

[Mitrazz]

Hi everybody, i have a problem with the node “column expression”.
I used this node in order to change a column that contains Gender. the gender is : F & M and now I want to have Female and Male instead of F and M. Can I make this change using column expression just one time or i should use this node two times?

[HansS]

Hi @Mitrazz

Why don’t use the Rule Engine node?

gr. Hans

[armingrudd]

Hi @Mitrazz,

As @HansS suggested, using the Rule Engine node seems a more straightforward approach to deal with this case.

However, if you still want to use the Column Expressions node, the expression should be like this:

if (column("gender") == "M") "Male"
else if (column("gender") == "F") "Female"