Look for repeated values (different rows) in the same column

Hi guys,
I have this data

I would like to check which values are repeated (show more than once) in the column I_ORDER_NR
(I want to exclude those that show only once)
what node could I use? what expression? Thanks

Hi @yoshiki3

Go for the Duplicate Row Filter node. Take a look a the Advanced tab and Add column showing duplicates. You can use a Row Filter node to filter the records by using this column.

gr. Hans


hi @yoshiki3,

Add RowID to the records than count the unique row ids by the I_ORDER_NR column.

Use RowID node for the first step and the GroupBy node for the second one, Grouping column should be the I_ORDER_NR column, function: Unique count RowIDs.


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.