Generate Missing Dates / Rows with Previous Row Pricing Data

[RKahle]

Data Query pulling all historical prices for ID: 1234 for the previous 30 days. Only (1) price was submitted for this ID on 2/1/2023. I would like Alteryx to generate rows #2 - #13, grouped by ID as there are multiple different ID’s in the actual data set, and then replace rows #2 - #13 with the data of the most recent previous row, (Row #1) so that there is (1) price for each day.

I am wondering if a QueryStart (Today - 30 days) and Queryfinish (Today) field is necessary to then get the Date difference between Effective Date and QueryStart dates.

Row #	Effective Date	ID	Price
1	2/1/2023	1234	$2.00

Row #	Effective Date	ID	Price
1	2/1/2023	1234	$2.00
2	2/2/2023	1234	$2.00
3	2/3/2023	1234	$2.00
4	2/4/2023	1234	$2.00
5	2/5/2023	1234	$2.00
6	2/6/2023	1234	$2.00
7	2/7/2023	1234	$2.00
8	2/8/2023	1234	$2.00
9	2/9/2023	1234	$2.00
10	2/10/2023	1234	$2.00
11	2/11/2023	1234	$2.00
12	2/12/2023	1234	$2.00
13	2/13/2023	1234	$2.00
…	…	…	…

[binu_acs]

@RKahle I created an input file based on your requirement and updated the workflow

[RKahle]

I'm sorry, I was attaching the wrong input. Please see attached. 

[binu_acs · Accepted solution]

@RKahle Updated workflow is attached. I added a new field called price, let me know if it works for you

[RKahle]

Yep, it looked like that worked! Thank you!