Start Free Trial

Alteryx Designer Desktop Discussions

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

Missing dates

BautistaC888
8 - Asteroid

I need to complete the following table with the missing dates and copy the values of the dates above.
Input:

BautistaCaparelli_1-1612298703627.png

Expected output:

BautistaCaparelli_2-1612298953995.png

Thank you.

 

 

 

1 REPLY 1
echuong1
Alteryx Alumni (Retired)

You can use the generate rows to create the missing dates. 

 

I started by using a multi-row formula, to determine the "current date" and the "next date" fields. I then used a generate rows to iterate through and generate any rows that were missing.

 

echuong1_1-1612300569896.png

 

 

Labels
Top Solution Authors