Dear all,
I am attempting to develop a solution for the situation where I possess data regarding sold goods, including the article date and quantity, while the rates are only available in a separate table. This information is presented in the form of price changes and the dates on which they were implemented. Therefore, I need to determine the appropriate rate for each date. Please refer to the attached example of both tables.
Additionally, it is possible that there may not be an active rate for an article in the “key” table; in such cases, I need to include the closest rate and provide a warning in the subsequent column. I tried my best but couldnt find solution.
Could someone please help me find the right approach? *Original dataset contains multiple articles (mre than a 1000 different) and almost 1 milion rows
The desired output table is attached.
Thanks for your help.
Example.knwf (88.1 KB)