Good afternoon everyone, how are you?
I have this file within knime, I would like it to be informed how many times it is repeated, and in most cases it says 1.
I assume you’re trying to count duplicate rows although its not completely clear. If my assumption is correct, add a column of ones to your table with the Constant Value Column node. Then use the GroupBy node and group by all the columns except your counter column. Aggregate the counter column with sum and subtract 1. This will give you the number of “repeats.”
4 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.