community Alteryx IO MyAlteryx
alteryx Community
Search
This Board
  • Global Community
  • This Category
  • This Board
  • Knowledge
  • Users
 cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Generating Missing Rows

Deano478
12 - Quasar
‎05-16-2023 04:52 AM

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_Week
1234501/06/20231Tom@Seine.comAnnual LeaveTomTom TestThursday
1234502/06/20231Tom@Seine.comAnnual LeaveTomTom TestFriday
1234503/06/20231Tom@Seine.comAnnual LeaveTomTom TestSaturday
1234504/06/20231Tom@Seine.comAnnual LeaveTomTom TestSunday
1234506/06/20231Tom@Seine.comAnnual LeaveTomTom TestTuesday
1234507/06/20231Tom@Seine.comAnnual LeaveTomTom TestWednesday
1234508/06/20231Tom@Seine.comAnnual LeaveTomTom TestThursday
1234509/06/20231Tom@Seine.comAnnual LeaveTomTom TestFriday
1234510/06/20231Tom@Seine.comAnnual LeaveTomTom TestSaturday
6789003/08/20231Marcus@Seine.comAnnual LeaveMarcusMarcus TestThursday
6789004/08/20231Marcus@Seine.comAnnual LeaveMarcusMarcus TestFriday
6789005/08/20231Marcus@Seine.comAnnual LeaveMarcusMarcus TestSaturday
6789006/08/20231Marcus@Seine.comAnnual LeaveMarcusMarcus TestSunday
6789008/08/20231Marcus@Seine.comAnnual LeaveMarcusMarcus TestTuesday
6789009/08/20231Marcus@Seine.comAnnual LeaveMarcusMarcus TestWednesday
6789010/08/20231Marcus@Seine.comAnnual LeaveMarcusMarcus TestThursday
6789011/08/20231Marcus@Seine.comAnnual LeaveMarcusMarcus TestFriday
6789012/08/20231Marcus@Seine.comAnnual LeaveMarcusMarcus TestSaturday
6789013/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

 

 

 

 

Labels:
Reply

Accepted SolutionSolved! Go to Solution.

3 REPLIES 3
ShankerV
17 - Castor
‎05-16-2023 05:03 AM

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

Reply
0 Likes
ShankerV
17 - Castor
‎05-16-2023 05:37 AM

Hi @Deano478 

 

Please find the output expected.

 

ShankerV_0-1684240275003.png

 

Step 1: Input

ShankerV_1-1684240296190.png

 

Step 2: 

ShankerV_2-1684240319171.png

ShankerV_3-1684240327337.png

 

Step 3:

 

ShankerV_4-1684240340333.png

 

ShankerV_5-1684240348571.png

 

 

Step 4:

 

ShankerV_6-1684240362454.png

 

ShankerV_7-1684240370726.png

 

Step 5:

ShankerV_8-1684240386341.png

 

ShankerV_9-1684240396990.png

 

Next step:

 

ShankerV_10-1684240413167.png

ShankerV_11-1684240422279.png

 

Next step:

 

ShankerV_12-1684240436825.pngShankerV_13-1684240444383.png

 

Next step:

 

ShankerV_14-1684240472554.png

 

ShankerV_15-1684240477952.png

 

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

Reply
binuacs
21 - Polaris
‎05-16-2023 06:56 AM

@Deano478 Another way of doing this

binuacs_0-1684245402101.png

 

Missing_Date_160523.yxmd
Reply
register for inspire
inspire session catalog
Labels
Top Solution Authors
View All