How to conditionally remove all values from row, leaving the empty row with original RowID?

[mlauber71]

@torczyk

Unfortunately, I wasn’t authorized to supply a sample of original data.

Often with questions in this forum I see what @bruno29a also is mentioning that the key to success is to break down one’s problem into a reproducible abstract (though complete) one that can be shared. Which is some work and effort but also more helpful in the end and might be more robust.

I would not go as far as to say that is happening in your case but more often than not I see businesses not caring about their data and processes and then hoping for some magic from tools like KNIME - which luckily they sometimes can provide.

@torczyk

I truly don’t like the way Joiner generates “new” row IDs, especially when it is joining on RowID.

Yes that can be challenging. If you need to preserve a special rowid there are ways but they are not that nice. Though it does make sense to think about what a Rowid represents for a (business) case.

I set up an example about rowid and joins recently:

Duplicated Row ID in a joiner

@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. https://kni.me/w/9hRISlxbpxxO-9h9 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 unders…

Handle RowIDs when using Joins – mlauber71