Hi all,
I have the following data with the material number and its value, and the date on which this value is set.
| Material No |
Date |
Value |
| 111111 |
26.01.2020 |
30 |
| 111111 |
11.02.2020 |
35 |
| 111111 |
13.12.2021 |
27 |
| 111111 |
01.04.2022 |
33 |
| 222222 |
11.01.2020 |
150 |
| 222222 |
01.04.2020 |
130 |
| 222222 |
02.01.2021 |
220 |
Now I need to create a table that will contain the current value between the two dates defined in the variables, filling them with data from the original table (gap filling)
Let vStart = MakeDate(2020,01,01);
Let vEnd = Today();
| Material No |
Date |
Value |
| 111111 |
01.01.2020 |
30 |
| 111111 |
02.01.2020 |
30 |
| 111111 |
03.01.2020 |
30 |
| Full table result, crushed for clarity |
|
| 111111 |
26.04.2022 |
33 |
| 111111 |
27.04.2022 |
33 |
| 222222 |
01.01.2020 |
150 |
| 222222 |
02.01.2020 |
150 |
| 222222 |
03.01.2020 |
150 |
| Full table result, crushed for clarity |
|
| 111111 |
26.04.2022 |
220 |
| 111111 |
27.04.2022 |
220 |
So the final result will include all possible days from the date range with possible materials and their values supplemented with data gaps, no matter if the value was earlier or not.
Any solution to this problem or information on how to do it?
Thank you in advance for your help.
Regards
Andrew
