Creating a matrix in which missing data will be completed in the time interval

Tuinel — Wed, 27 Apr 2022 11:13:24 GMT

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

topic Creating a matrix in which missing data will be completed in the time interval in Connectivity & Data Prep

Creating a matrix in which missing data will be completed in the time interval