Here is a solution using a JMP List as the input for the sold out fruit. I also convert the new column to static values by deleting the formula at the end, since if you save the data table, and then reopen it, the column will fail if a JMP list by the name of soldList is not present
Names Default To Here( 1 );
dt = New Table( "Fruit",
New Column( "Fruit Name",
character,
values( {"Apple", "Banana", "Durain", "Pear", "Orange"} )
)
);
soldList = {"Apple", "Durain"};
dt << New Column( "Sold Out",
character,
formula( If( N Rows( Loc( soldList, :Fruit Name ) ), "Y", "N" ) )
);
dt:Sold Out << delete formula;
Jim