Can somebody help me please with the problem below? I have tried all kinds of nodes but no result yet.
Below a simplified example of the data in question:
|Identifier||Characteristic 1||Characteristic 2|
- I want to select those rows that have the same identifier, but have a different value for Characteristic 1
- I want to select those rows that have the same identifier and where Characteristic 1 of one row is the same as Characteristic 2 for another row.
Thank you so much in advance!