Hi,
I have below set of data
Dept | Type | Country |
IT | DEVELOPER | UK |
IT | DEVELOPER | US |
IT | DEVELOPER | FR |
HR | SALARY | AU |
HR | SALARY | IN |
ADMIN | Asset | UK |
ADMIN | Asset | US |
ADMIN | Asset | AU |
ADMIN | Asset | FR |
I want to update the count column based on group level of Dept and Type :
My expected output is in count column is
Dept | Type | Country | Count |
IT | DEVELOPER | UK | 3 |
IT | DEVELOPER | US | 3 |
IT | DEVELOPER | FR | 3 |
HR | SALARY | AU | 2 |
HR | SALARY | IN | 2 |
ADMIN | Asset | UK | 4 |
ADMIN | Asset | US | 4 |
ADMIN | Asset | AU | 4 |
ADMIN | Asset | FR | 4 |
Can you please assist me.
Hi @alt_tush
Step 1: Summarize tool
Dept -> Group By
Type -> Group By
Type -> Count
Step 2: Join tool
Connect the Left join to Input tool
Connect the Right join to Summarize tool
Join key
Dept = Dept
Type = Type
Note: Deselect two columns which will be repeated (Right Dept. Right Type)
With the above 2 steps, you can get the same output as expected.
Many thanks
Shanker V