Fill date gaps

Comments

3 comments

  • Frances Angulo

    You can use the "explode range" function to create a data set of date sequences and then use that output as an outer join to actual set. You can then use the "denullify" function to replace the non matches with zeros. 

    Give it s try! 

    1
    Comment actions Permalink
  • Xavier

    Thanks Frances, following your insight I've found the EXPAND_DATE_RANGE that seems to do exactly what I wanted.

    0
    Comment actions Permalink
  • Frances Angulo

    Ah yes! My suggestion would have required a formatting of a date. Well done! 

    0
    Comment actions Permalink

Please sign in to leave a comment.