Welcome to the JMP User Community!

Latest Discussions

• Choose output of a new column based on name of the column

  I have column names with student names and the class/es that they’ve attended:
  
  Name, Class A1, Class A2, Class A3, Class A, Class B
  
  Where not every Class column has an input. On my script, how can I create a new column where it will only choose the output where:
  
  If a student attended all “A” Classes, the output is from column Class A.
  
  If a student attended Class A1 through A2 or A3, the output is from...

  Yula

  Discussions |

  Oct 23, 2023 11:03 PM

  1422 views | 3 replies

• Match case ( 0 )

  HelloI would like to find test names that continue "pcie0" sometimes in lower or upper formatI understand I should use Match case ( 0 )I have added it to my script but received errorcan you check what I should change in my script?  Column(dt, "PARAMETR") << Set Each Value( If( Contains(( :TEST_NAME,"pcie0")), Match case( 0 ),"PCIE0",:PARAMETR)); 

  Dennisbur

  Discussions |

  Oct 23, 2023 9:59 PM

  1443 views | 4 replies

• Data table order is commingled

  Hi folks,   I have three FRF (txt style) files to be imported into JMP, and I had the following script to import and process the data. I have one description table that has three description items, which need to be assigned to the FRF data table in an ascending order. For example:   z-ht_0.414 needs to be assigned to ccf_23101106.FRF z-ht_0.464 needs to be assigned to ccf_23101703.FRF z-ht_0.514 n...

  TDK_Long

  Discussions |

  Oct 23, 2023 4:26 PM

  1830 views | 4 replies

• Create a timeline horizontal bar chart with varying category over time

  Hi All,I have a data table with a bunch of units that fall into different categories for different periods of time.  This data set is defined in the data table as here: There are four columns of data – (i) unit identifier (a discrete number), (ii) start date, (iii) end date and (iv) category.  The category column lists the categories into which the unit falls into between the start and end time.  ...

  Velagandula

  Discussions |

  Oct 23, 2023 2:28 PM

  3911 views | 3 replies

• How to get limits from from column and use it for other columns via JSL?

  The attached data table has got limits (LSL/USL) for each measured parameter (Current, Resistance) in the respective columns. Without changing the data table format, how do I get the limits for each parameter to show as reference lines for example when the Median is plotted vs PartID (as in the script in the attached data table)?One way I can think of doing this is to save the LSL/USL into the col...

  Neo

  Discussions |

  Oct 23, 2023 1:48 PM

  4109 views | 11 replies