I want to filter my table rows so that in each PDB name category, only the first row would be included. I tried to write the exact row names using “Include rows by RowID” but it doesn’t work for more than one Id.
I also tried to tell it to exclude rows from the second row for each PDB name category which also didn’t work.
Any ideas?
Hi @tahami
Use a groupBy node where PDB is the grouping column and select the first instances of all other columns under the aggregation tab
Perfect! that worked nicely, thanks
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.