Table from multiple queries :: resample/time-align

Hi all -

I have multiple queries returning time series I want to put in one table - a column per query. In general this works by merging the single results but since the time series are not time-stamp-aligned, I get empty cells as can be seen on below image. I would like to implement one of the following if possible:

  • Fill the empty cells with the last known value (no idea how)
  • Resample the data so they are time-stamp aligned (this I tried with an expression but no success)



approach expression

I found this old thread with a similar question, unfortunately no answer so far:

Hoping anyone has some thoughts on this to share.