Update the Count column on group level

[alt_tush]

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.

[ShankerV]

Hi @alt_tush 

This can be achieved in 2 steps.

1. Summarize tool

2. Join tool

Many thanks

Shanker V

[ShankerV]

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