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 |
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
Hi @caldowd1998! Did any of these solutions work for you?