Add missing dates with null returns on other columns

Question

Been working way too long to figure this out.  See attached data set.  You will see missing dates of 2020-08-08 and 2020-08-09.  All I want to do is add new rows to the data set that return these missing dates with null values in the Sum_Cash field along with the existing dates and values in the Sum_Cash field... Easy right??

Alteryx example.xlsx

RolandSchubert · Accepted Answer

Hi @Jon12 ,

you can use a Summarize tool to find the first/last date, create a complete list of all dates use a Generate Rows tool and join the list to your input data.

Let me know if it works for you.

Best,

Roland

atcodedog05 · Accepted Answer

Hi @Jon12

Here is how you can do it.

Workflow:

Hope this helps : )

messi007 · Accepted Answer

@Jon12,

Please see below :

Attached the workflow.

Regards,