how to replicate value if it is friday

[Sshasnk]

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

[afv2688]

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

[Emil_Kos]

Hi @Sshasnk,

This workflow isn't so clean as the one provided by @afv2688 by this should work for you.

The output:

Probably you would need to a formula to @afv2688 solution that would add one or two days depending on which day it is. 

[Qiu]

@Sshasnk 

Tried with some different tools.