Icon

Filter Cols with single diff value

Sample dataIterate the columnsone at a timeOutputs Filtered TableSort AscendingSkim first 2 rowsSort DescendingSkim first 2 rowsThese are thefirst and lasttwo rowsof datasetWe now have a single rowwith columnsRow0Row1Row2Row3As a single row, these can nowbe compared in the Rule EngineMake sure the 4rows are sortedin correct orderWe will want known, default naming of the rows whenwe transpose, so replaceRowIDDetermine ifcolumnname is to be excluded based on ruleExclude current columnif it is named in the ExcludeColumnNamevariabkeExcludeColumnNameas a variable to use in column filterTable Creator Column ListLoop Start Loop End (ColumnAppend) Sorter Row Filter Sorter Row Filter Concatenate Transpose Sorter RowID Rule Engine Column Filter Table Rowto Variable Sample dataIterate the columnsone at a timeOutputs Filtered TableSort AscendingSkim first 2 rowsSort DescendingSkim first 2 rowsThese are thefirst and lasttwo rowsof datasetWe now have a single rowwith columnsRow0Row1Row2Row3As a single row, these can nowbe compared in the Rule EngineMake sure the 4rows are sortedin correct orderWe will want known, default naming of the rows whenwe transpose, so replaceRowIDDetermine ifcolumnname is to be excluded based on ruleExclude current columnif it is named in the ExcludeColumnNamevariabkeExcludeColumnNameas a variable to use in column filterTable Creator Column ListLoop Start Loop End (ColumnAppend) Sorter Row Filter Sorter Row Filter Concatenate Transpose Sorter RowID Rule Engine Column Filter Table Rowto Variable

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: bbate
Created at: 2022-10-02
On NodePit since: 2022-10-03
Last update: 2024-04-27
Created with KNIME version: v4.6.3

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

Try NodePit Runner!