How To generate all Dates based on Random dates column.

[Manish2109]

Hi Team, 

We have requirement to generate all the dates a Date column based on the Random date column we have. See below the attached data:

Id	Resource Date	Value
201	13-01-2024	100
201	17-01-2024	200
201	22-01-2024	300
401	13-01-2024	150
401	17-01-2024	250
401	22-01-2024	350

The result/Output which is required is : 

Id	Resource Date	Date	Value
201	13-01-2024	13-01-2024	100
201	13-01-2024	14-01-2024	100
201	13-01-2024	15-01-2024	100
201	13-01-2024	16-01-2024	100
201	17-01-2024	17-01-2024	200
201	17-01-2024	18-01-2024	200
201	17-01-2024	19-01-2024	200
201	17-01-2024	20-01-2024	200
201	17-01-2024	21-01-2024	200
201	22-01-2024	22-01-2024	300
401	13-01-2024	13-01-2024	150
401	13-01-2024	14-01-2024	150
401	13-01-2024	15-01-2024	150
401	13-01-2024	16-01-2024	150
401	17-01-2024	17-01-2024	250
401	17-01-2024	18-01-2024	250
401	17-01-2024	19-01-2024	250
401	17-01-2024	20-01-2024	250
401	17-01-2024	21-01-2024	250
401	22-01-2024	22-01-2024	350

Please suggest how we can achieve the above result.

[Bhushan_Mahajan]

@Manish2109 Please refer below article.

https://community.qlik.com/t5/Design/How-to-populate-a-sparsely-populated-field/ba-p/1470637