Urgent help to calculate the date

Hello Team,

I need urgent help in calculating the price validity dates.
I have a product with multiple missing validity dates for its price. I need to follow the below logic to find the actual validity date for the price.

  1. If SAP column already has valid from and valid till dates then just copy them to Actual valid from and Actual Valid till columns

  2. If SAP Valid from and SAP valid till is empty but there is only one price then Actual valid from is July 2018 and Actual valid till is jun 2019

  3. If SAP Valid from and valid till are empty but there are multiple prices then first Actual valid from is June but the valid till should be one day before the next price valid from date.

  4. In case 3 if valid from of the second price is missing, it should be calculated by taking the first month from the quarter column

Quarter column full forms
JAS - july aug sep
OND - October november december.

Please find the attached workbook to see the problem and expected solution.dateCalc.xlsx (13.8 KB)

I am really looking forward for your reply. since I need to present the knime model to the team on friday.

Best regards,
Sahil

Hi @Sahil1 -

Seems like you have a fair amount of logic that you need to implement here. Have you thought about using the Column Expressions node for this task? It uses Javascript syntax.

@armingrudd has written a very nice blog post that details some common operations you can perform using the node.

3 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.