Generate rows for each client

[MohamedBourehil]

Hello guys, 

I have this table below,

Clients	Client_ID_End_Date	Start Date
Client1	01/05/2020	01/01/2020
Client2	01/11/2019	01/09/2019
Client3	01/08/2019	01/05/2019

and i want to generate another column whch contains all the dates between the start and end dates for each client, in order to have a similar output as in the table below:

Clients	Client_ID_End_Date	Start Date	Sample date
Client1	01/05/2020	01/01/2020	01/05/2020
Client1	01/05/2020	01/01/2020	01/04/2020
Client1	01/05/2020	01/01/2020	01/03/2020
Client1	01/05/2020	01/01/2020	01/02/2020
Client1	01/05/2020	01/01/2020	01/01/2020
Client2	01/11/2019	01/09/2019	01/11/2019
Client2	01/11/2019	01/09/2019	01/10/2019
Client2	01/11/2019	01/09/2019	01/09/2019

I've tried the Generate Rows and the Multi-Row Formula tools but it didn't provide the desired outcome, i'd appreciate it if anyone can help me on this one,

Thanks!

[bhrmitra · Accepted solution]

Hi MohamedBourehil,

Using Generate Rows you can achieve the result.

If this solves your issue please mark the answer as correct and also hit the like button, if not let me know! I've attached my workflow for you to download if needed.

Thanks,

Abhra Mitra

[MohamedBourehil]

Thanks a lot @bhrmitra,

Your answer works perfectly, i've made the same thing before except that i've only put "=" in the condition expression thinking of it as a stop criterion.

Thanks again !