I need to filter row content based on a condition or a flag, but I need to leave an empty row with its original RowID. Let’s say my table looks like this: RowID Val1 Val2 Val3 Val4 Valid 0 2 5 2 7 TRUE 1 5 4 12 2 FALSE 2 7 2 9 5 TRUE 3 1 11 4 9 TRUE 4 0 7 2 5 FALSE 5 3 5 7 9 TRUE and I’d like to end up with such table: RowID Val1 Val2 Val3 Val4 Valid 0 2 5 2 7 TRUE 1 FALSE 2 7 2 9 5 TRUE 3 1 11 4 9 TRUE 4 FALSE 5 3 5 7 9 TRUE The condition (VALID) column may or may not be preserved, it doesn’t matter.

@torczyk added two options to generate such IDs: [image] And indeed sortable RowIDs are a thing with KNIME. Maybe they allow IDs to have a long format when Integer will not do it. Or you might have to construct something elaborate with a string and taking the number of Rows into account …

mlauber71 February 21, 2022, 5:45pm 9

@torczyk for what it is worth here is my suggestion

3 Likes