Welcome to the JMP User Community!

Latest Discussions

• How to match and fill column/rows based on results

  Hi, I was wondering if this is possible do to write a script for an analysis similar to the one below? In one column ("Month"), I have all 12 months of the year (January to December), with each month having multiple rows in the same column. In the next column ("Condition"), there is a condition for that month, either "A" or "B". In a 3rd column ("Result"), I want to write a formula that analyzes t...

  cheeseistasty

  Discussions |

  Jun 11, 2021 1:22 PM

  1791 views | 3 replies

• 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

  898 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

  1735 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

  1605 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

  14915 views | 10 replies