725596_en-US

liliconcom

Contains no longer an option when selecting values from a numeric row

I recently ran into this issue with a very large customer. In earlier versions of JMP, they were using Contains to ID error codes from a numeric column in a fashion like this

This is no longer available in JMP 17. Two questions:

1. Have you run into this issue?

2. How can this selection process be replicated with no more than the same number of clicks and as efficiently (the table may have 100M rows).

Re: Contains no longer an option when selecting values from a numeric row

Explore Outliers has a Nines tab, but that's a lot more clicks. What about mapping the script below to a keyboard shortcut? That could be even fewer clicks.

Try(
	col = (Current Data Table() << get selected columns())[1];
	Current Data Table() << Select Where( Contains( Char( col ), "9999" ) );
);

Re: Contains no longer an option when selecting values from a numeric row

@DonMcCormack , are they always 9999? If so, what about setting the column property missing value codes then using data filer under rows with the red triangle option for filter to select missing?  Row selection in 17 for is missing does not seem to work. Assuming they want to avoid a script

Re: Contains no longer an option when selecting values from a numeric row

local data filter, distribution and other platforms will recognize it. But if their goal is to find the missing values and the missing value codes, then maybe column property and global data filter. A couple of extra clicks than before. 18 it is still an issue.

Explore missing respects missing value codes.