Generate Rows for missing dates and retain other column values

[Saravanan13]

Hello All,

I am looking to generate rows for missing dates corresponding to each Doc ID, Also values in the other columns should also be retained.

Can anyone assist on this

[ArtApa · Accepted solution]

Hi @Saravanan13 - Here is a solution that generates rows for every DOC ID with values in other columns, which are currently Null: