Icon

sophisiticated concatenate

solution alternative: don't read column names in the first place I had this more elegant solution in mind, but I'm not sure how to continue with this Node Golf ;-) readsCommision Affinity MatchreadsAffinity DealsNode 3Node 4sort this outputto determinesheet orderloop overaffinity valuesfilteraffinityfilteraffinityfixes affinity columnfixes missingaffinity valuefor Row Filterget backcolumn namesget backcolumn nameskeep somedistance!excelcopy& paste;-)Node 16loop endaffinity valuesNode 18loop oversheetsNode 20loop endsheetswhat now?don't readColumn namessame resultand appendSum(Payment) Excel Reader Excel Reader ExtractColumn Header ExtractColumn Header find unique affinityvalues to loop over Table Row ToVariable Loop Start Row Filter Row Filter Missing Value Missing Value Concatenate Concatenate Add Empty Rows Concatenate Excel Writer Variable Loop End Read ExcelSheet Names Table Row ToVariable Loop Start Excel Reader Loop End Row Splitter Excel Reader Row Splitter aggregate Payment solution alternative: don't read column names in the first place I had this more elegant solution in mind, but I'm not sure how to continue with this Node Golf ;-) readsCommision Affinity MatchreadsAffinity DealsNode 3Node 4sort this outputto determinesheet orderloop overaffinity valuesfilteraffinityfilteraffinityfixes affinity columnfixes missingaffinity valuefor Row Filterget backcolumn namesget backcolumn nameskeep somedistance!excelcopy& paste;-)Node 16loop endaffinity valuesNode 18loop oversheetsNode 20loop endsheetswhat now?don't readColumn namessame resultand appendSum(Payment)Excel Reader Excel Reader ExtractColumn Header ExtractColumn Header find unique affinityvalues to loop over Table Row ToVariable Loop Start Row Filter Row Filter Missing Value Missing Value Concatenate Concatenate Add Empty Rows Concatenate Excel Writer Variable Loop End Read ExcelSheet Names Table Row ToVariable Loop Start Excel Reader Loop End Row Splitter Excel Reader Row Splitter aggregate Payment

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: david
Created at: 2022-01-02
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.5.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!