Add a new column with a condition based on other columns

[giad]

Hi,
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
Giad

[rd2575691]

Hello,

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

[giad]

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”?

Giad

[rd2575691]

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

[giad]

Ok great it works!
Many thanks