Icon

Just KNIME It _​ Challenge 005

Just KNIME It _ Challenge 005
Challenge 5: Date to Fiscal Year contract_dates_table.xlsxfiscal_years_lookup_table.xlsx...Challenge 05's provided table resulted to be just as ruke exampleFormat DateExtract NumericMonth and Yearfrom Contract DatesAssign FYFY Integer to StringJoin "FY" + YearClean Up Columns Excel Reader Excel Reader String to Date&Time Extract Date&TimeFields Math Formula Number To String String Manipulation Column Filter Challenge 5: Date to Fiscal Year contract_dates_table.xlsxfiscal_years_lookup_table.xlsx...Challenge 05's provided table resulted to be just as ruke exampleFormat DateExtract NumericMonth and Yearfrom Contract DatesAssign FYFY Integer to StringJoin "FY" + YearClean Up Columns Excel Reader Excel Reader String to Date&Time Extract Date&TimeFields Math Formula Number To String String Manipulation Column Filter

Nodes

Extensions

Links