title: To carry forward the update to next hour if not received using KQL
body: <pre><code>  Time                Product   Value
  2022-06-20T01:00:00Z   B1        25
  2022-06-20T01:00:00Z   B2        46
  2022-06-20T01:00:00Z   B3        18
  
  2022-06-20T02:00:00Z   B1        26
  2022-06-20T02:00:00Z   B2        40
  </code></pre>
  <p>How can i carry forward B3 to 2022-06-20T02:00:00Z if i have not received any updates for B3 at 2022-06-20T02:00:00Z</p>
  <p>Required output:</p>
  <pre><code>  Time                Product   Value
  2022-06-20T01:00:00Z   B1        25
  2022-06-20T01:00:00Z   B2        46
  2022-06-20T01:00:00Z   B3        18
  
  2022-06-20T02:00:00Z   B1        26
  2022-06-20T02:00:00Z   B2        40
  2022-06-20T01:00:00Z   B3        18
  </code></pre>