Icon

Creating a sequence of columns v2

One rowColumn name andvaluesNew headerVlookupOne columnReplace IDsPaid amountsPaid amountsNode 11Sum per dataNew nameyearMonthpaid_amountMissing valuesYearMonthFrom 2010to 2030All combinationsConcatenate yearand monthChunk Loop Start Column Splitter Insert ColumnHeader Column Expressions Loop End (ColumnAppend) RowID Table Creator Joiner Table Creator Concatenate GroupBy Column Rename Table Rowto Variable VariableExpressions Missing Value Empty Table Creator Table Creator Counter Generation Cross Joiner Column Expressions One rowColumn name andvaluesNew headerVlookupOne columnReplace IDsPaid amountsPaid amountsNode 11Sum per dataNew nameyearMonthpaid_amountMissing valuesYearMonthFrom 2010to 2030All combinationsConcatenate yearand monthChunk Loop Start Column Splitter Insert ColumnHeader Column Expressions Loop End (ColumnAppend) RowID Table Creator Joiner Table Creator Concatenate GroupBy Column Rename Table Rowto Variable VariableExpressions Missing Value Empty Table Creator Table Creator Counter Generation Cross Joiner Column Expressions

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: rbarri
Created at: 2022-08-26
On NodePit since: 2022-08-27
Last update: 2024-04-28
Created with KNIME version: v4.6.0

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

Try NodePit Runner!