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

Handle the missing dates

Yoga321
7 - Meteor

Hi all,.

 

I have a data set like shown in image 1 with the date of plans for the year:

 Image 1Image 1

But I need the remaining dates as Office  dynamically generated as shown in image 2:

Image 2Image 2

I am new to alteryx!!!!!!

Can anyone help in this!!!!!

Regards,

Yoganantha Prakash G P

6 REPLIES 6
neilgallen
12 - Quasar

Hello @Yoga321 and welcome.

 

The trick here is to generate a dataset that contains all possible dates, and then summarize from there after joining to your existing planned dates.

 

The attached workflow should get you there, but I'll admit I haven't checked this all that thoroughly against a wide variety of scenarios, just the one you described.

 

The two generate rows tools 1) creates dates in the planned ranges and 2) creates every date for each person on the list.

 

The other piece is the tile tool which identifies the sequence of each section.

 

Missind Dates.PNG

jdunkerley79
ACE Emeritus
ACE Emeritus

I did it a slightly different way to @neilgallen

 

2018-12-03_14-59-05.png

 

I take each row and see if it is the expected start date after the last. If not then I create an extra row. Finally union back together.

 

Example attached

 

neilgallen
12 - Quasar

well done @jdunkerley79. Always expect there to be a simpler method.

Yoga321
7 - Meteor

Hi jdunkerley79,

 

I got the partial solution as below:

a_date_3.PNG

 

For this employee from date 01-01-2018 to 28-01-2018 is missing and also after 28-06-2018. 29-06-2018 to 31-12-2018 is missing!

 

Can you help in this!!

Yoga321
7 - Meteor

Hi neilgallen,

 

Thanks for the reply and got the solution as requested.

jdunkerley79
ACE Emeritus
ACE Emeritus

I had only handled back filling.

 

Have adjusted example to add the mssing final rows

Labels