Date Range Comparison between Page 1 and Page 2 sheets.
Hello team, I am looking for the knime solution for the below scenario.
Here is the sample date validation file , i need similar way of knime solution.
First check date range in Page 2 along with ID.
Then check and loop Page1 as similar like below ,
match ID first with both sheet , then check if the Dates on Date column of sheet Page - 1 is between the Dates range of Page 2 (Start and End dates) and comparision formula should be (Date column dates >= Start date of page and <= to End date of Page2 date) then knime should give result as match for dates matching rows else mismatch as similar as below, i have thousands of rows similar pattern.
Please assist.
###
Summary
This text will be hidden