Hello Knime Expert…
I need your help in creating workflow for selection process of price.
Select price on basis of period in which it falls…
|product as on 31-12-2019||Valid from (1)||valid till (1)||price-1||valid from (2)||valid till (2)||price-2|
Here product “a” is purchase on 31-12-2019 thus as per requirement we have to apply it’s price basis on it’s purchase date period i.e valid from (2) 01-12-219 to valid till(2) 31-11-2022 price(2) 45 will be our correct output
|product as on 31-12-2019||Price|
Thanks in advance.