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â