Generate rows between dates

[caldowd1998]

Hi community

I have a table like the top one below which i am trying to convert to match the table below, so there is a row for every date. How would i do this ?

many thanks !

Product	Valid From	Valid Too	Cost
Playstation	01.01.2022	05.01.2022	£100

Product	Date	Cost
Playstation	01.01.2022	£100
Playstation	02.01.2022	£100
Playstation	03.01.2022	£100
Playstation	04.01.2022	£100
Playstation	05.01.2022	£100

[davidskaife]

Hi @caldowd1998 

The generate rows tool is your friend here:

I've attached a sample workflow for you to look at - note you'd need to format/change the date fields if they are not specifically in a date format

[DataNath]

One way of doing this with generate rows - If you're not precious about the format of your date being dd.mm.yyyy then you can just remove the formula tool I've added:

[binu_acs]

@caldowd1998 one way of dong this

[ddiesel]

Hi @caldowd1998! Did any of these solutions work for you?