I m looking for a formula in knime on how to get a result by checking if all data in a single column have the same value
Hi @Kia31
I donât know a formula to check if all data in a single column have the same value. But I know there is node, the: Constant Value Column Filter node.
gr. Hans
Hello @Kia31 , and welcome to the KNIME community.
You can use âRankâ with Ranking Mode == Dense, targeting your $column_item$.
Then âGroupByâ Manual Aggregation == $Sum(rank)$
IF âSum(rank)â value MATCHES âNumber Rowsâ from âExtract Table Dimensionâ THEN all your values have same value.
BONUS: It works for both, String and Numeric column types.
BR
Some other possibilitiesâŚ
-
Use Duplicate Row Filter on the column (removing duplicates) followed by Extract Table Dimensions, and if the âNumber Rowsâ flow variable is 1, then they are all the same
-
GroupBy âunique countâ, and tick whether you wish to include or exclude missing values. Then a Table Row to Variable node will create you a unique count variable that you can test for â=1â