Update the Count column on group level

Question

Hi,

I have below set of data

DeptTypeCountryITDEVELOPERUKITDEVELOPERUSITDEVELOPERFRHRSALARYAUHRSALARYINADMINAssetUKADMINAssetUSADMINAssetAUADMINAssetFR

I want to update the count column based on group level of Dept and Type :

My expected output is in count column is

DeptTypeCountryCountITDEVELOPERUK3ITDEVELOPERUS3ITDEVELOPERFR3HRSALARYAU2HRSALARYIN2ADMINAssetUK4ADMINAssetUS4ADMINAssetAU4ADMINAssetFR4

Can you please assist me.

ShankerV · Answer

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

ShankerV · Answer

Hi @alt_tush

This can be achieved in 2 steps.

1. Summarize tool

2. Join tool

Many thanks

Shanker V