Hii guys, please help me with this, Im working on my project and Ive been stuck for quite a long time ><
What should I do, If I want to count how many repeated values in knime? All my values are in separated columns and rows.
For example, this is what I currently have:
| Apple | Watermelon | Apple | Banana |
The output I need is :
|Apple |6 |
Which node should I use, and how do I use it? Thankyou so much!
Welcome to the forum @KainLittleCloth .
There are probably a few ways to do this. What comes to mind first is using an Unpivoting node so that you have all the values in a single column, then a GroupBy node which aggregates using Count.
An example workflow is here .
7 Likes
Hi there! thankyou so much !! i managed to find out how to do for unpivoting table!
But i could not solve how am i able to count the data using group table node?
Thankyou so much!! after some tries using your method, I got the output i wanted!! Appreciate your time a lot :)) Have a good day! ^^
3 Likes
system
March 9, 2022, 5:34am
6
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
