Duplicated Row ID in a joiner

[mlauber71]

@MatOk welcome to the KNIME forum. You might want to check your IDs and make sure you always have the right ID. You can either keep the ID in a separate column and use that or if you want to use RowdID you might have to make sure your RowID is the one you want to use.

I hope this example might help.

Handle RowIDs when using Joins – mlauber71

You can always convert the current RowID to a column and you can convert a column to a RowID.

return $$ROWID$$;

If you want to handle your duplicates and understand about them you can read this article:

School of duplicates - and how to deal with them

Dealing with duplicates is a constant theme with data scientist. And a lot of things can go wrong. The easiest ways to deal with them is SQL’s GROUP BY or DISTINCT. Just get rid of them and be done. But as this examples might demonstrate this might not always be the best option. Even if your data provider swears your combined IDs are unique especially in Big Data scenarios there might still be lurking some muddy duplicates and you should still be able to deal with them. And you should be able t…