Icon

Identify Last Column

Create DatesNode 4Total # RowsKeep # Rows# Rows - 1Keep # Rows - 1Node 10Node 11Test AginstCurrent DateRead DataKeep DateColumnsDate Stringsto RowsKeep Final ColumnCheck DateDiff< 10Next to LastColumnCreateLastColumnLastColumnNode 21Filter N Columns String to Date&Time Extract TableDimension Table Rowto Variable Row Filter Math Formula Column Filter Table Rowto Variable Merge Variables Date&TimeDifference Excel Reader Column Filter Transpose Row Filter Column Expressions Table Rowto Variable Math Formula Table Rowto Variable Merge Variables Create DatesNode 4Total # RowsKeep # Rows# Rows - 1Keep # Rows - 1Node 10Node 11Test AginstCurrent DateRead DataKeep DateColumnsDate Stringsto RowsKeep Final ColumnCheck DateDiff< 10Next to LastColumnCreateLastColumnLastColumnNode 21Filter N Columns String to Date&Time Extract TableDimension Table Rowto Variable Row Filter Math Formula Column Filter Table Rowto Variable Merge Variables Date&TimeDifference Excel Reader Column Filter Transpose Row Filter Column Expressions Table Rowto Variable Math Formula Table Rowto Variable Merge Variables

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: genef
Created at: 2023-08-16
On NodePit since: 2023-08-18
Last update: 2024-11-21
Created with KNIME version: v4.7.6

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

Try NodePit Runner!