Select the first rows based on a criteria

insomned

Hello, 

I would like to select the first N rows that contain a particular word (Boolean, in my case). For example:

Name     Age     Bool

Dora      13        True

Nelly      14        True

Kate       17        False

Michelle   19      True

I want to now have only the first 2 rows (ie the first rows, which contained "True"). 

Thank you!

NicoleJohnson

If you use a Sample Tool in conjunction with a Filter, that should give you what you need! You can configure them in either direction (Sample then Filter, or Filter then Sample). 

Sample: Choose "First N" and then set N to 2, and Group By your particular word field (Boolean). This will keep the first 2 records for each word in the Boolean field... if you use this tool before Filter, you'll have 2 Trues and 2 Falses

Filter: Filter for only those records where "Boolean" is true

Cheers,

NJ