Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@Manish2109 Please refer below article.
https://community.qlik.com/t5/Design/How-to-populate-a-sparsely-populated-field/ba-p/1470637