Generating Missing Rows

Question

hHi Everyone,

i'm back again with another issue. Essentially my workflow is nearly done I just have one piece left to the puzzle.

I have a dataset which can be seen below and as you can see it's missing certain rows that should be a Monday.

For example you can see for Marcus you have 03/08/2023 up until 13/08/2023. He is missing the row for 07/08/2023.

Employee_IDLeave_DateApprovedEmailHoliday_TypeFirst_NameEmployee_NameDay_of_The_Week1234501/06/20231Tom@Seine.comAnnual LeaveTomTom TestThursday1234502/06/20231Tom@Seine.comAnnual LeaveTomTom TestFriday1234503/06/20231Tom@Seine.comAnnual LeaveTomTom TestSaturday1234504/06/20231Tom@Seine.comAnnual LeaveTomTom TestSunday1234506/06/20231Tom@Seine.comAnnual LeaveTomTom TestTuesday1234507/06/20231Tom@Seine.comAnnual LeaveTomTom TestWednesday1234508/06/20231Tom@Seine.comAnnual LeaveTomTom TestThursday1234509/06/20231Tom@Seine.comAnnual LeaveTomTom TestFriday1234510/06/20231Tom@Seine.comAnnual LeaveTomTom TestSaturday6789003/08/20231Marcus@Seine.comAnnual LeaveMarcusMarcus TestThursday6789004/08/20231Marcus@Seine.comAnnual LeaveMarcusMarcus TestFriday6789005/08/20231Marcus@Seine.comAnnual LeaveMarcusMarcus TestSaturday6789006/08/20231Marcus@Seine.comAnnual LeaveMarcusMarcus TestSunday6789008/08/20231Marcus@Seine.comAnnual LeaveMarcusMarcus TestTuesday6789009/08/20231Marcus@Seine.comAnnual LeaveMarcusMarcus TestWednesday6789010/08/20231Marcus@Seine.comAnnual LeaveMarcusMarcus TestThursday6789011/08/20231Marcus@Seine.comAnnual LeaveMarcusMarcus TestFriday6789012/08/20231Marcus@Seine.comAnnual LeaveMarcusMarcus TestSaturday6789013/08/20231Marcus@Seine.comAnnual LeaveMarcusMarcus TestSunday

I have no idea whether this particular job can be done in Alteryx but any assistance is greatly appreciated to get this done.

Cheers in advance

ShankerV · Accepted Answer

Hi @Deano478

Please find the output expected.

Step 1: Input

Step 2:

Step 3:

Step 4:

Step 5:

Next step:

Note: If all the column values needs to be filled, use multi row formula to fill the null values based on your requirement.

Many thanks

Shanker V

binu_acs · Accepted Answer

@Deano478 Another way of doing this