I have a dataset that does not include weekends I have to replicate the value from Friday but change the date
Example:
Price | date | day |
12 | 2020-12-03 | Thur |
74 | 2020-12-04 | Fri |
20 | 2020-12-07 | Mon |
45 | 2020-12-08 | Tue |
output:
price | date | day |
12 | 2020-12-03 | Thu |
74 | 2020-12-04 | Fri |
74 | 2020-12-05 | Sat |
74 | 2020-12-06 | Sun |
20 | 2020-12-07 | Mon |
45 | 2020-12-08 | Tue |
Steps:
1. Add sat and Sun line
2. price column should be whatever value above but the date should change as ex: 2020-12-05
Hello @Sshasnk,
this workflow replaces fridays with friday saturday and sunday and then parses them into different lines:
NOTE: Although it is not shown in the image the date is also modified
Regards