Icon

Multiline-Cells v3

Replacement for RuleEngine read exampletableextract 2 linecolumn headers(top port)table with adjustedcol headerssplit by new lineungroupsplit cellssplit byequal signconvert 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-nameif there is nomultiline split,keep the orig. valueelse the split valueif multiline(aka missing valfrom prev node) thenadd text to RemarkExcel Reader Row Splitter Insert ColumnHeader Column HeaderAdjustment Cell Splitter Ungroup Cell Splitter 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) Column Expressions Column Expressions Replacement for RuleEngine read exampletableextract 2 linecolumn headers(top port)table with adjustedcol headerssplit by new lineungroupsplit cellssplit byequal signconvert 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-nameif there is nomultiline split,keep the orig. valueelse the split valueif multiline(aka missing valfrom prev node) thenadd text to RemarkExcel Reader Row Splitter Insert ColumnHeader Column HeaderAdjustment Cell Splitter Ungroup Cell Splitter 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) Column Expressions 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: 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!