Icon

2019_​08_​14_​ExtractingMinimum&IndexFromColumns

Extracting Minimum and corresponding Index
Extracting Minimum and corresponding IndexThis workflow demonstrates how to extract Index (Column Name) after calculating minimum value from selectedcolumns. Two option are given and both include using Loops and flow variables.Forum link: https://forum.knime.com/t/index-match-in-knime/17492 Input DataGet minimumTranspose dataGet Index in ColumnAdd Index to RowStart LoopOnly one row per iterationConcatenate final resultsLoop over each number columnSelect minimumGet Index in ColumnConcatenate resultsChange name to MinimumFinal result Table Creator Column Aggregator Transpose RowID Cell Replacer Table Row ToVariable Loop Start Row Filter Loop End Column ListLoop Start Element Selector RowID Loop End Column Rename Column Appender Extracting Minimum and corresponding IndexThis workflow demonstrates how to extract Index (Column Name) after calculating minimum value from selectedcolumns. Two option are given and both include using Loops and flow variables.Forum link: https://forum.knime.com/t/index-match-in-knime/17492 Input DataGet minimumTranspose dataGet Index in ColumnAdd Index to RowStart LoopOnly one row per iterationConcatenate final resultsLoop over each number columnSelect minimumGet Index in ColumnConcatenate resultsChange name to MinimumFinal result Table Creator Column Aggregator Transpose RowID Cell Replacer Table Row ToVariable Loop Start Row Filter Loop End Column ListLoop Start Element Selector RowID Loop End Column Rename Column Appender

Nodes

Extensions

Links