Idea from here: Re: Eliminating Duplicate Rows (keeping first duplicate)
I only have JMP15 installed, so I cannot test it this solution will work on JMP12.
Names Default To Here(1);
dt = New Table("Untitled 2",
Add Rows(10),
Compress File When Saved(1),
New Column("Fruit",
Character,
"Nominal",
Set Values(
{"Apple", "Strawberry", "Lemon", "Banana", "Orange", "banana", "Apricot",
"Watermelon", "Kiwi", "Lingonberry"}
),
Set Display Width(75)
),
New Column("Color",
Character(16),
"Nominal",
Set Values(
{"Red", "Red", "Yellow", "Yellow", "Orange", "Green", "Orange", "Green",
"Green", "Red"}
)
),
New Column("Number",
Numeric,
"Continuous",
Format("Best", 12),
Set Values([2, 3, 2, 4, 5, 4, 5, 4, 1, 0])
)
);
dt << select where(Col Min(Row(), :color) < Row() & :Color != "Yellow")
//dt << Delete Rows;
-Jarmo