Icon

kn_​forum_​26479_​double_​linked_​list_​group

Implement multi row formula

Implement multi row formula

inner loop Implement multi row formulahttps://forum.knime.com/t/help-needed-with-multi-row-formula/26479/10 data/Actual_test.xlsxNode 2STARTGROUPEmpty Rowor ? Rowis firstINNERLOOPSTART_temp_file.table=> initially savethe first line_temp_file.tablePosition =1_temp_file.tableINNERLOOPENDPositionJoin nextlineby "Next" from topand "Id" from bottomNode 2181st lineand restback togetherENDGROUPdata/Expected_Position.xlsxNode 222compareresultsknime://knime.workflow/data/data_result.xlsx Excel Reader (XLS) Sorter Group Loop Start Rule-basedRow Splitter Table Row ToVariable Loop Start Table Writer Table Reader ConstantValue Column Table Writer Loop End Math Formula Joiner String To Number Concatenate Loop End Excel Reader (XLS) String To Number Joiner Excel Writer (XLS) inner loop Implement multi row formulahttps://forum.knime.com/t/help-needed-with-multi-row-formula/26479/10 data/Actual_test.xlsxNode 2STARTGROUPEmpty Rowor ? Rowis firstINNERLOOPSTART_temp_file.table=> initially savethe first line_temp_file.tablePosition =1_temp_file.tableINNERLOOPENDPositionJoin nextlineby "Next" from topand "Id" from bottomNode 2181st lineand restback togetherENDGROUPdata/Expected_Position.xlsxNode 222compareresultsknime://knime.workflow/data/data_result.xlsxExcel Reader (XLS) Sorter Group Loop Start Rule-basedRow Splitter Table Row ToVariable Loop Start Table Writer Table Reader ConstantValue Column Table Writer Loop End Math Formula Joiner String To Number Concatenate Loop End Excel Reader (XLS) String To Number Joiner Excel Writer (XLS)

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: m_lauber
Created at: 2020-09-14
On NodePit since: 2020-09-15
Last update: 2024-05-02
Created with KNIME version: v4.2.1

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

Try NodePit Runner!