Welcome to the JMP User Community!

Latest Discussions

• JMP Script filter multiple parameters from multiple columns

  See for example, I have data table below, with column name A, B, C, and I want to:Filter Column "A" by exclude "a" and "c" & Filter Column "B" by exclude "e" and "f" & Filter Column "C" by exclude "g" and "h"In the end, I want to delete rows that being excluded above based on the 3 criteria from each column. How can I script to make this happen? ABCadgbehcfiaeibfhcdgaeibdgcfh

  aaronjiang

  Discussions |

  Jun 11, 2021 12:23 PM

  1163 views | 1 replies

• Setting Spec Limits using Column Data

  Hi,I have a query that produces a data table with parameter test results and spec limits listed in different columns (example below). Is there a script that can set the spec limits to each parameter? Would I need to rearrange my data table for this to work? Sample IDParameterLSLUSLResultSample 1Parameter 15106Sample 2Parameter 15107Sample 3Parameter 2143Sample 4Parameter 2142Sample 5Parameter 3102...

  Austin

  Discussions |

  Jun 11, 2021 8:41 AM

  2288 views | 3 replies

• Conditional value labels for missing values

  I wonder if there's a way to set up conditional value labels based on values from two columns. If I refer to the snapshot table below, I have "column 1" which could either be filled or empty and I also have "column 2" which either be filled or empty. What I'm trying to do is for "column 2" to be formatted like "Column 3". Which is: (i) values formatted to a date format if there's a value AND the "...

  Djtjhin

  Discussions |

  Jun 11, 2021 8:38 AM

  2255 views | 5 replies

• Simple method to copy multiple column properties to a new data table?

  I need to copy the column properties for 82 columns to a new data table which has the same number of columns and same column names.  I seem to remember in the past that there was a quick and simple method, using a few mouse clicks and GUI interface (non-scripting method) to do this.  I don't see these options anymore in any of the menus or sub-menus.  Am I making this up, did this capability never...

  notoriousapp

  Discussions |

  Jun 11, 2021 8:29 AM

  16730 views | 10 replies

• Quantiles with missing values

  If I have a column named X with 100 values which is a sequence from {1-100}, and I want to retrieve the 10 smallest values, I know I can use the command below:dt = current data table(); temp1 = dt:X << get values; temp2 = quantile(0.1,temp1); dt << get rows where(:X<temp2);Let's say I'm replacing the 10 largest values (i.e. 91-100) with missing values, is there a way to get the same 10 smallest va...

  Djtjhin

  Discussions |

  Jun 11, 2021 7:45 AM

  1617 views | 3 replies