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