Icon

justknimeit-5

contract_dates_tablefiscal_years_lookup_tablejoin both tables togetherconvertstring > datedifference with startdifference with endremove duplicatetidy colsJoin the main tablecheck date range ANDif Contract Date is outof range interactive view for select fiscal yearExcel Reader Excel Reader Cross Joiner String to Date&Time Date&TimeDifference Date&TimeDifference DuplicateRow Filter Column Filter Joiner Missing Value Rule-basedRow Filter Definition offiscal year contract_dates_tablefiscal_years_lookup_tablejoin both tables togetherconvertstring > datedifference with startdifference with endremove duplicatetidy colsJoin the main tablecheck date range ANDif Contract Date is outof range interactive view for select fiscal yearExcel Reader Excel Reader Cross Joiner String to Date&Time Date&TimeDifference Date&TimeDifference DuplicateRow Filter Column Filter Joiner Missing Value Rule-basedRow Filter Definition offiscal year

Nodes

Extensions

Links