'Need to achieve the below output using Kusto Query language(KQl)
Sample Data. We are expected to receive Products everyday with Total counts.
| TimeStamp | Product Desc | Product Code | Available count |
|---|---|---|---|
| 2022-01-02T09:00:00Z | Berries | 111 | 10 |
| 2022-01-02T09:00:00Z | Chocolate | 222 | 20 |
| 2022-01-02T09:00:00Z | Mayo | 333 | 30 |
| 2022-01-03T09:00:00Z | Berries | 111 | 15 |
| 2022-01-03T09:00:00Z | Chocolate | 222 | 22 |
| 2022-01-04T09:00:00Z | Berries | 111 | 30 |
If no product received on that particular day, i have to show the last date received product as the current day.
| TimeStamp | Product Desc | Product Code | Available count |
|---|---|---|---|
| 2022-01-03T09:00:00Z | Berries | 111 | 15 |
| 2022-01-03T09:00:00Z | Chocolate | 222 | 22 |
| 2022-01-03T09:00:00Z | Mayo | 333 | 30 |
| 2022-01-04T09:00:00Z | Berries | 111 | 30 |
| 2022-01-04T09:00:00Z | Chocolate | 222 | 22 |
| 2022-01-04T09:00:00Z | Mayo | 333 | 30 |
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
