Icon

CountIf across tabulated data

File 2File 1Rename "row" columnsRename "row" columnsNode 5Node 6File 1File 2Rename "row" columnstabulated torow formatRename "row" columnstabulated torow formatMake a "key"Make a "key"Count of each time a proteinis found in a give column(ie count, grouping by the "key")Lookup count values by keyAdd CountIf to origjnal ColumnValueStrip off "header"rowsValue columns as IntegerMissing countif values to 0Re-tabulate thedata tooriginal formatAdd counterto retain originalorder laterSort by counterAdd backstripped header rowsto reformoriginaltableTidy upOpen File or Folder Table Creator Table Creator Column Rename(Regex) Column Rename(Regex) Unpivoting Unpivoting Excel Reader Excel Reader Column Rename(Regex) Unpivoting Column Rename(Regex) Unpivoting String Manipulation String Manipulation GroupBy Cell Replacer Math Formula Row Splitter String To Number Missing Value Pivoting Counter Generation Sorter Concatenate Column Filter File 2File 1Rename "row" columnsRename "row" columnsNode 5Node 6File 1File 2Rename "row" columnstabulated torow formatRename "row" columnstabulated torow formatMake a "key"Make a "key"Count of each time a proteinis found in a give column(ie count, grouping by the "key")Lookup count values by keyAdd CountIf to origjnal ColumnValueStrip off "header"rowsValue columns as IntegerMissing countif values to 0Re-tabulate thedata tooriginal formatAdd counterto retain originalorder laterSort by counterAdd backstripped header rowsto reformoriginaltableTidy upOpen File or Folder Table Creator Table Creator Column Rename(Regex) Column Rename(Regex) Unpivoting Unpivoting Excel Reader Excel Reader Column Rename(Regex) Unpivoting Column Rename(Regex) Unpivoting String Manipulation String Manipulation GroupBy Cell Replacer Math Formula Row Splitter String To Number Missing Value Pivoting Counter Generation Sorter Concatenate Column Filter

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: brian
Created at: 2021-08-10
On NodePit since: 2022-02-06
Last update: 2024-04-30
Created with KNIME version: v4.4.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!