Check how many days are missing

[Sshasnk]

I have a dataset where some of the date is missing I have to fill those rows 

Example:

date	value
2020-12-21	12
2020-12-23	13
2020-12-24	24
2020-12-28	47
2020-12-29	96
2020-12-30	56

output:

date	value	missing number of days
2020-12-21	12	1
2020-12-22	12	1
2020-12-23	13
2020-12-24	24	3
2020-12-25	24	3
2020-12-26	24	3
2020-12-27	24	3
2020-12-28	47
2020-12-29	96
2020-12-30	56

So, the Number of days missing after the 22nd was 1 day and after 24th was 3 so I have put 3 next to it

[JosephSerpis]

Hi @Sshasnk an approach would be to use a generate row tools and then also use the Multi-Row tool to produce the output you describe. I've mocked up a workflow that showcases that approach.

[AkimasaKajitani]

Hi @Sshasnk 

The procedure of solution is the below.

1. Calculate diff days by Multi row formula.

2. Generate lack rows by Generate row.