QUESTION: Generate Rows - Every Friday after a Thursday

[Czaggy]

Hello everyone,

I have the following Table showing Dates (holidays) and their DateWeekDay.

Date	DateWeekDay
21.05.2020	Thu
01.06.2020	Mo

I want generate additional rows for every Friday, that comes after a Thursday - I tried using the Generate Rows Tool, but I can't seem to find the solution. Here is what it should look like:

Date	DateWeekDay
21.05.2020	Thu
22.05.2020	Fri
01.06.2020	Mo

It is not important if the Column "DateWeekDay" has the "Fri" tag in it - I can just replace "NULL" with "Fri" later on. First I just want to create the rows (I have multiple Thursday in my entire data set).

Hope someone can help me out!

Thank you very much!

BR Markus

[RolandSchubert · Accepted solution]

Hi @Czaggy ,

I would select the "Thursdays", add one day to the date and add the new dates to the list of existing dates.  I've created a sample workflow. Let me know if it works for you.

Best,

Roland