Icon

Multiline-Cells v2

read exampletableextract 2 linecolumn headers(top port)table with adjustedcol headerssplit by new lineungroupsplit cellssplit byequal signreplace missingnon multi linecells with singlevaluesconvert string to numbers to getmissing valindicationif multiline(aka missing valfrom prev node) thenadd text to Remarkloop throughcolumnscreateSplit Column Name# of cols > 5 = top port# of cols <= 5 = bottom portvar-switch-portonly keeporiginal colsNode 26Node 27var-adjusted-col-nameExcel Reader Row Splitter Insert ColumnHeader Column HeaderAdjustment Cell Splitter Ungroup Cell Splitter Rule Engine String To Number Column Expressions Column ListLoop Start String Manipulation(Variable) CASE Switch Start Create variablefor Case Switch ReferenceColumn Filter Loop End (ColumnAppend) CASE Switch End String Manipulation(Variable) read exampletableextract 2 linecolumn headers(top port)table with adjustedcol headerssplit by new lineungroupsplit cellssplit byequal signreplace missingnon multi linecells with singlevaluesconvert string to numbers to getmissing valindicationif multiline(aka missing valfrom prev node) thenadd text to Remarkloop throughcolumnscreateSplit Column Name# of cols > 5 = top port# of cols <= 5 = bottom portvar-switch-portonly keeporiginal colsNode 26Node 27var-adjusted-col-nameExcel Reader Row Splitter Insert ColumnHeader Column HeaderAdjustment Cell Splitter Ungroup Cell Splitter Rule Engine String To Number Column Expressions Column ListLoop Start String Manipulation(Variable) CASE Switch Start Create variablefor Case Switch ReferenceColumn Filter Loop End (ColumnAppend) CASE Switch End String Manipulation(Variable)

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: m1pegv
Created at: 2023-12-08
On NodePit since: 2023-12-11
Last update: 2024-04-27
Created with KNIME version: v4.6.4

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

Try NodePit Runner!