Generate Rows for missing dates

[Saravanan13]

Hello All,

I am looking to get missing dates and generate rows for each Doc ID separately. Also the missing dates rows value should be null.

Can anyone assist on this please.

[FinnCharlton]

Hi @Saravanan13 ,

This workflow should achieve this for you:

[Felipe_Ribeir0]

Hi @Saravanan13 

Here it is, generating the rows for each DOC ID/Missing Date.

[FinnCharlton]

Have noticed you wanted the missing dates for each Doc ID, I think this is more what you are looking for:

[Saravanan13]

Hello Finn,

Thank you so much for the assistance, Sorry I missed to mention the additional columns in the data source, I would want to get all the values in the columns as well.

[RobertOdera · Accepted solution]

Hi, @Saravanan13 

Thanks for the question.

If this works for you, please mark it as an acceptable solution.

Cheers!