How to divide the standard hours into the rows?

[Amrit_Sahoo]

I want to feel standard hours of 8 into rows for each emp id and date. Find the below table where I want to create standard hours in alteryx.

Emp ID	Date	Hours Charged	Standard Hours
1	23-07-2021	4	2
1	23-07-2021	3	2
1	23-07-2021	3	2
1	23-07-2021	2	2
2	23-07-2021	4	2
2	23-07-2021	3	2
2	23-07-2021	3	2
2	23-07-2021	2	2
3	23-07-2021	4	2
3	23-07-2021	3	2
3	23-07-2021	3	2
3	23-07-2021	2	2

Any help will be really appreciated.

Amrit

[atcodedog05 · Accepted solution]

Hi @Amrit_Sahoo 

This is more clear. Here is how you can do it.

Workflow:

1. Using select tool to convert Emp ID to string. This will be useful for later mapping

2. Using summarize tool groupby Emp ID & Date to get count of rows.

3. Standard Hr is 8/[count].

4. Using find and replace mapping on Emp ID add  Standard Hours column to data.

Hope this helps : )

[Amrit_Sahoo]

Thanks @atcodedog05. Really appreciated