I would like to convert my monthly values to daily values (i.e. just duplicating the values I have for each item for each day of the month).
I currently have this:
| Record | Commodity | Value | Date |
1 | Oil | 800 | 2010-01-01 |
| 2 | Natural Gas | 700 | 2010-01-01 |
| 3 | Diesel | 600 | 2010-01-01 |
| 4 | Oil | 900 | 2010-02-01 |
| 5 | Natural Gas | 650 | 2010-02-01 |
| 6 | Diesel | 200 | 2010-02-01 |
But would like it to be like:
| Record | Commodity | Value | Date |
1 | Oil | 800 | 2010-01-01 |
| 2 | Oil | 800 | 2010-01-02 |
| 3 | Oil | 800 | 2010-01-03 |
| 4 | Oil | 800 | 2010-01-04 |
| 5 | Oil | 800 | 2010-01-05 |
| 6 | Oil | 800 | 2010-01-06 |
| etc | etc | etc | etc |
And so on for each commodity for year and each month till the end of my dataset (which goes till 2021, but I would like it to be dynamic).
I have tried some formulas and row generations but am not getting too far. Any help is appreciated!
Thanks so much,
Akarsh
