Missing dates need completing

Sammy22

I have a large dataset for previous 2 years of data as below which has daily data but some days are missing. I need a row for every date even if it is missing (weekends etc). so below i would end up with 2/2/2021 with the price the same as the 1st. How can i add in the missing dates and make the price the same as the previous day?

Date	Code	Price
1/2/2021	a	2
1/2/2021	b	3
1/2/2021	c	5
3/2/2021	a	4
3/2/2021	b	4
3/2/2021	c	4

atcodedog05

Hi @Sammy22 

Here is how you can do it.

Workflow:

1. Using formula tool to convert to Alteryx date format. If your date is already in format you can skip this step.

2. Using sort tool sort ascending on date and code.

3. Using multi-row formula group on code getting next date.

4. Using generate row tool to generate missing dates.

5. Using sort tool sort ascending on date and code.

Hope this helps : )

fill missing dates.yxmd