Add missing dates with null returns on other columns

[Jon12]

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??

[RolandSchubert · Accepted solution]

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 solution]

Hi @Jon12 

Here is how you can do it.

Workflow:

Hope this helps : )

[messi007 · Accepted solution]

@Jon12,

Please see below : 

Attached the workflow.

Regards,

[atcodedog05]

Happy to help : ) @Jon12 

Cheers and have a nice day!