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
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.
Hi @Sshasnk
The procedure of solution is the below.
1. Calculate diff days by Multi row formula.
2. Generate lack rows by Generate row.