Hi,
How can I filter my dataset for the second row in each 'book'?
How can I keep only the record in red?
Solved! Go to Solution.
@wonka1234 are there only ever 2 books? If so, could just use the sample tool like so:
Before -
After -
If not, you can create an ID for the records of each book and then just filter those that = 2:
Before -
After -
Hi @wonka1234 ,
Here's a solution which keep these rows only with two methods
Let me informed if it works as you want.
Cheers !