Icon

20230103 Pikairos Replace First Date of the month with First Day of same month

20221230 Pikairos Replace First Date of the month with First Day of same month

This workflow brings a possible answer to question asked in post #58039 on the KNIME forum:

I want to convert the latest date of every month into the first date of that particular month.



Your DatesReorder Day & Yearin DateExtractYear - Month - Day - Hour - MinuteThis String Manipulationmakes sure thatMonth, Day,Hour & Minuteare made of 2 charactersLag Monthto Comparetwo Month RowsLaterIf Lagged Monthis different thatCurrent Thenset Day to 01CombineNew Day - Month - YearKeep onlyDesired ColumnsTable Creator String Manipulation String to Date&Time Extract Date&TimeFields String Manipulation(Multi Column) Lag Column Rule Engine String Manipulation Column Filter Your DatesReorder Day & Yearin DateExtractYear - Month - Day - Hour - Minute This String Manipulationmakes sure thatMonth, Day,Hour & Minuteare made of 2 charactersLag Monthto Comparetwo Month RowsLaterIf Lagged Monthis different thatCurrent Thenset Day to 01CombineNew Day - Month - YearKeep onlyDesired ColumnsTable Creator String Manipulation String to Date&Time Extract Date&TimeFields String Manipulation(Multi Column) Lag Column Rule Engine String Manipulation Column Filter

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: Molina
Created at: 2022-12-30
On NodePit since: 2023-01-04
Last update: 2024-05-02
Created with KNIME version: v4.5.2
Tags: DateTimeString to Date & TimeLag Column

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

Try NodePit Runner!