Add a new column with a condition based on other columns

I need to add a new column to this table:


in which I must calculate if CONNECTED is the first category for each ID, I want to see 1, otherwise 0.
In my example attached, I will see 0 because the first category is ENROLL.
Shall I use the rule engine? or the math formula? and how can I set the condition if CONNECTED is the first category for each ID?

Many thanks


Something like this?
conditional new column.knwf (23.0 KB)


Thanks but it does not work. I do not have the column called First category, I only have Category field. Why do you have a column “first category”?


Its just an intermediary column to find the first category for a given ID. It gets discarded in the end.

Ok great it works!
Many thanks

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.