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

alteryx community questions.xlsx

ArtApa

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

GenMissingDatesAA.yxmd