Icon

Rename column to last date of the month

Rename the column Amount to the last date of the current month.

Instructions: Always reset the first node so that it can generate the current date when executed. If it is not reset, it will use the date that was previously generated

Get currentdateGet first dayof current monthConvert backto dateGet last dateof current monthby doing+1 month - 1 dayNode 5Simulated dataread from ExcelNode 7Create Date&TimeRange Date&Time to String String to Date&Time Date&Time Shift Table Rowto Variable Table Creator Column Rename Get currentdateGet first dayof current monthConvert backto dateGet last dateof current monthby doing+1 month - 1 dayNode 5Simulated dataread from ExcelNode 7Create Date&TimeRange Date&Time to String String to Date&Time Date&Time Shift Table Rowto Variable Table Creator Column Rename

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: bruno
Created at: 2022-11-30
On NodePit since: 2022-11-30
Last update: 2024-04-27
Created with KNIME version: v4.6.3

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

Try NodePit Runner!