How can I filter duplicate row id that have this pattern (1) in its name?
This node filter about the field value not about the row id.
Use the RowID node. Choose the option Append RowID column: Create new column with the RowID values. And then apply the Duplicate Row Filter on this new created column.
1 Like
Hi @ahmed_gomaa
Or you can try the Row Filter node and select “Include row by row ID” and input this regex pattern:
((?!\(1\)).)*
1 Like
It works. Thanks. But, what if there is more than one duplicate row ID. In other words, (2), (3), etc.
1 Like
((?!\(\d\)).)*
Thanks a lot, you are a professional one. I want to learn about regular expression. what is your recommendation?
1 Like
2 Likes
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.