Icon

Month names and adding year information

Month names and adding year information based on table position

Demonstrating determining month number, and deciding if it is in current or next year by its position in the table.

Sample DataNormalise the monthnames to 3 charactersGet MonthNumberGetRowPositionSample DataSample DataSample DataNormalise the monthnames to 3 charactersand determine the yearGet MonthNumberNormalise the monthnames to 3 charactersGet MonthNumberNormalise the monthnames to 3 charactersNormalise the monthnames to 3 charactersGet MonthNumberGetRowPositionGetRowPositionGetRowPositionSample Datadecide the yearjoin month and year columnstidy upSample DataExtract Data Tablefrom Delimited Text String Manipulation String Manipulation String Manipulation Extract Data Tablefrom Delimited Text Extract Data Tablefrom Delimited Text Extract Data Tablefrom Delimited Text String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation Extract Data Tablefrom Delimited Text Rule Engine String Manipulation Column Filter Extract Data Tablefrom Delimited Text Sample DataNormalise the monthnames to 3 charactersGet MonthNumberGetRowPositionSample DataSample DataSample DataNormalise the monthnames to 3 charactersand determine the yearGet MonthNumberNormalise the monthnames to 3 charactersGet MonthNumberNormalise the monthnames to 3 charactersNormalise the monthnames to 3 charactersGet MonthNumberGetRowPositionGetRowPositionGetRowPositionSample Datadecide the yearjoin month and year columnstidy upSample DataExtract Data Tablefrom Delimited Text String Manipulation String Manipulation String Manipulation Extract Data Tablefrom Delimited Text Extract Data Tablefrom Delimited Text Extract Data Tablefrom Delimited Text String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation String Manipulation Extract Data Tablefrom Delimited Text Rule Engine String Manipulation Column Filter Extract Data Tablefrom Delimited Text

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: BATEB031
Created at: 2023-06-08
On NodePit since: 2023-06-08
Last update: 2024-11-24
Created with KNIME version: v4.7.1

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!