Generating Missing Rows

[Deano478]

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_ID	Leave_Date	Approved	Email	Holiday_Type	First_Name	Employee_Name	Day_of_The_Week
12345	01/06/2023	1	Tom@Seine.com	Annual Leave	Tom	Tom Test	Thursday
12345	02/06/2023	1	Tom@Seine.com	Annual Leave	Tom	Tom Test	Friday
12345	03/06/2023	1	Tom@Seine.com	Annual Leave	Tom	Tom Test	Saturday
12345	04/06/2023	1	Tom@Seine.com	Annual Leave	Tom	Tom Test	Sunday
12345	06/06/2023	1	Tom@Seine.com	Annual Leave	Tom	Tom Test	Tuesday
12345	07/06/2023	1	Tom@Seine.com	Annual Leave	Tom	Tom Test	Wednesday
12345	08/06/2023	1	Tom@Seine.com	Annual Leave	Tom	Tom Test	Thursday
12345	09/06/2023	1	Tom@Seine.com	Annual Leave	Tom	Tom Test	Friday
12345	10/06/2023	1	Tom@Seine.com	Annual Leave	Tom	Tom Test	Saturday
67890	03/08/2023	1	Marcus@Seine.com	Annual Leave	Marcus	Marcus Test	Thursday
67890	04/08/2023	1	Marcus@Seine.com	Annual Leave	Marcus	Marcus Test	Friday
67890	05/08/2023	1	Marcus@Seine.com	Annual Leave	Marcus	Marcus Test	Saturday
67890	06/08/2023	1	Marcus@Seine.com	Annual Leave	Marcus	Marcus Test	Sunday
67890	08/08/2023	1	Marcus@Seine.com	Annual Leave	Marcus	Marcus Test	Tuesday
67890	09/08/2023	1	Marcus@Seine.com	Annual Leave	Marcus	Marcus Test	Wednesday
67890	10/08/2023	1	Marcus@Seine.com	Annual Leave	Marcus	Marcus Test	Thursday
67890	11/08/2023	1	Marcus@Seine.com	Annual Leave	Marcus	Marcus Test	Friday
67890	12/08/2023	1	Marcus@Seine.com	Annual Leave	Marcus	Marcus Test	Saturday
67890	13/08/2023	1	Marcus@Seine.com	Annual Leave	Marcus	Marcus Test	Sunday

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]

Hi @Deano478 

Yes, this is possible.

Step 1: Use the Summarize tool to get the Min date and Max date for each employee ID

Step 2: Use the Generate rows tool to achieve creating the rows for missing date

Step 3: Join the output with the Input

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Deano478 

Please find the output expected.

Step 1: Input

Step 2: 

Step 3:

Step 4:

Step 5:

Next step:

Next step:

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

[binuacs · Accepted solution]

@Deano478 Another way of doing this