Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to divide the standard hours into the rows?

Amrit_Sahoo
7 - Meteor

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 IDDateHours ChargedStandard Hours
123-07-202142
123-07-202132
123-07-202132
123-07-202122
223-07-202142
223-07-202132
223-07-202132
223-07-202122
323-07-202142
323-07-202132
323-07-202132
323-07-202122

 

Any help will be really appreciated.

 

Amrit

11 REPLIES 11
Luke_C
17 - Castor

Hi @Amrit_Sahoo , what would you expect the final output to look like? I'm not sure I understand fully.

atcodedog05
22 - Nova
22 - Nova

Hi @Amrit_Sahoo 

 

As @Luke_C suggested can you please provide the sample input and expected output so that we can help you better 🙂.

Amrit_Sahoo
7 - Meteor

My Input would be 

Emp IDDateHours Charged
123-07-20214
123-07-20213
123-07-20213
123-07-20212
223-07-20214
223-07-20213
223-07-20213
223-07-20212
323-07-20214
323-07-20213
323-07-20213
323-07-20212

 

My output would be 

Emp IDDateHours ChargedStandard Hours
123-07-202142
123-07-202132
123-07-202132
123-07-202122
223-07-202142
223-07-202132
223-07-202132
223-07-202122
323-07-202142
323-07-202132
323-07-202132
323-07-202122

Hi @Amrit_Sahoo 

 

Are you looking to summarize the data by EID and Date similar to the below? Cheers!

christine_assaad_0-1627062737106.pngchristine_assaad_1-1627062761726.png

 

Amrit_Sahoo
7 - Meteor

My Input Looks Like

 

Emp IDDateHours Charged
123-07-20214
123-07-20213
123-07-20213
123-07-20212
223-07-20214
223-07-20213
223-07-20213
223-07-20212
323-07-20214
323-07-20213
323-07-20213
323-07-20212

 

The expected output is 

 

Emp IDDateHours ChargedStandard Hours
123-07-202142
123-07-202132
123-07-202132
123-07-202122
223-07-202142
223-07-202132
223-07-202132
223-07-202122
323-07-202142
323-07-202132
323-07-202132
323-07-202122
Amrit_Sahoo
7 - Meteor

@christine_assaad I don't want to use summarize tool since there are other dependants. I am looking for a solution by using multi row formula.

 

Amrit_Sahoo
7 - Meteor

My Input is till hours charged. I need the standard hours which is 8 per day to be equally divided to each row based on Emp ID & Date.

Amrit_Sahoo
7 - Meteor

Input

Emp IDDateHours Charged
123-07-20214
123-07-20213
123-07-20213
123-07-20212
223-07-20215
223-07-20213
223-07-20213
323-07-20214
323-07-20213
323-07-20213
323-07-20212
323-07-20211

 

I would need the output to be as below:

 

Emp IDDateHours ChargedStandard Hours
123-07-202142
123-07-202132
123-07-202132
123-07-202122
223-07-202152.67
223-07-202132.67
223-07-202132.67
323-07-202141.6
323-07-202131.6
323-07-202131.6
323-07-202121.6
323-07-202111.6
Luke_C
17 - Castor

Hi @Amrit_Sahoo 

 

Here's an example, I used summarize to get the count of records for each ID and use to split the 8 hours.

 

Luke_C_0-1627065709552.png

 

Labels