Retrieve distinct

Hi folks I want to do a simple thing in a microflow and do not know why this seems to be so difficult on Mendix. With SQL this is so simple....   Use case I have an entity with District codes. This is associated with the employee entity. I want to detect all districts that have more than 1 employee linked to it. How such a simple thing can be achieved?   I believe I need to make a loop on the district code, get from the association the linked employees.....from there I am stucked...  I appreciate any help Regards Felix
1 answers

Create a new list for Employees before the loop. Inside your loop add a List operation Activity with Count function. Then add a decision shape to check if your Count returns more than one and then insert Change List activity for Employees with Add function to store your results.