Rule engine on doublets

Dear all

I wish to go thorugh a variable ‘Patient ID’ and assing ‘yes’ in a new row for each patient id there is there more than once.

Can someone help me do that?

Best, Christopher

Maybe you try a group by and count, kept the IDs with >1 then insert a constant value column with „yes“ and left join that back to your data.