Icon

Lookup in different files with CountIf

Convert the whole column into a list/collection One rowat a timeA whole columnat a timeFile 1File 2Node 7Node 8Node 9This is just tobe able to useColumn AppenderThis is just tobe able to useColumn AppenderNode 16Node 17Node 18Keep only thenecessarycolumnsNode 21Node 22Check if theProteinis in the ColumnNode 24 Chunk Loop Start Column ListLoop Start Excel Reader Excel Reader Transpose Create CollectionColumn Column Rename RowID RowID Loop End Column Appender Column Filter Column Filter GroupBy Loop End Rule Engine Split CollectionColumn Convert the whole column into a list/collection One rowat a timeA whole columnat a timeFile 1File 2Node 7Node 8Node 9This is just tobe able to useColumn AppenderThis is just tobe able to useColumn AppenderNode 16Node 17Node 18Keep only thenecessarycolumnsNode 21Node 22Check if theProteinis in the ColumnNode 24 Chunk Loop Start Column ListLoop Start Excel Reader Excel Reader Transpose Create CollectionColumn Column Rename RowID RowID Loop End Column Appender Column Filter Column Filter GroupBy Loop End Rule Engine Split CollectionColumn

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: bruno
Created at: 2021-08-10
On NodePit since: 2022-02-06
Last update: 2024-11-21
Created with KNIME version: v4.3.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!