Generate Rows for missing dates

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.

alteryx community questions.xlsx

Preparation

Accepted answers

Hi, @Saravanan13

Thanks for the question.

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

Cheers!

GenerateRowsForMissingDates.yxzp

All comments

Hi @Saravanan13 ,

This workflow should achieve this for you:

Generate Dates.yxmd

Hi @Saravanan13

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

Generate Rows for missing dates.yxmd

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

Generate Dates for each DocID.yxmd

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.

alteryx community questions.xlsx

Hi, @Saravanan13

Thanks for the question.

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

Cheers!

GenerateRowsForMissingDates.yxzp

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703