Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
What is the expected output ?
e.g
If(Group Name = 'Director', 1 ,0 ) as Flag
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.
Something like below ? If I understood correctly.
If(Aggr(Count({<Group = {'Director'}>}ID),ID) > 0,'Present','Absent')
Thanks,
Ashutosh
Sorry, I was hoping for in the script.
Thanks
I think I've done it, using group by
Great. You can use Group by in script and Aggr() in the expression.