If statement per id number

[D19PAL]

Hi,

How do I do an if statement or any other way for each I'd check if theres tick for group name and check if there is a director in group name.

I'd,group name,tick

1,manager,tick

1,director,

2,manager, tick

2,manager 

Thanks

[AshutoshBhumkar]

Hello,

What is the expected output ?

e.g

If(Group Name = 'Director', 1 ,0 ) as Flag

[D19PAL]

I guess this will do it by rows, I want to check all rows by ID, so if ID 1 has 5 rows, I want to check if any of those rows in group name have director.

[AshutoshBhumkar]

Something like below ? If I understood correctly.

If(Aggr(Count({<Group = {'Director'}>}ID),ID) > 0,'Present','Absent')

Thanks,

Ashutosh

[D19PAL]

Sorry, I was hoping for in the script.

Thanks 

[D19PAL]

I think I've done it, using group by

[AshutoshBhumkar]

Great. You can use Group by in script and Aggr() in the expression.