Welcome to the JMP User Community!

Latest Discussions

• dt: image - missing?

  What is the correct way to check if an image in a data table is missing?... and why is there a difference between the column formula and the JSL questionis missing(:pet[5]) Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class Families.jmp" ); dt[[4],"pet"]=.; New Column( "is missing",Formula( Is Missing( :pet ) )); New Column( "is empty", Formula( Is Empty( :pet ) )); New Column( "is nu...

  hogi

  Discussions |

  Mar 31, 2024 8:45 AM

  1576 views | 3 replies

• Column() vs As Column() vs datable:column vs dt:As name("column")

  JSL has several ways to refer to columns. Let's open a data table first. Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Bands data.jmp" );Now we create a table script that has something like this.dt = current data table(); print(dt:timestamp == Column(dt, "timestamp")); // 0 print(Column(dt, "timestamp")==As Column(dt, "timestamp")); //0In automated scripts (for example, a graph), when a...

  FN

  Discussions |

  Mar 30, 2024 11:54 AM

  7331 views | 13 replies

• Using a string variable inside a graph builder script

  Early in my JMP script, I define a string variable like this: Trim0 = "trim_lvl_a";There is a column in my data table by the name of trim_lvl_a.  Later in the script, I create a Graph Builder script like this:  dt << New Script( "maps", Graph Builder( Size( 550, 647 ), Graph Spacing( 5 ), Variables( X( :X ), Y( :Y ), Group Y( :Name( "Tambient (degC)" ) ), Wrap( :LotWafer ), Col...

  fbm73

  Discussions |

  Mar 29, 2024 2:55 PM

  1205 views | 1 replies

• how to get Plot of several Plots time vs dimensions

  I would like to have a script for the dimension control by time, for this I need something like the sketch below. The Date Table is attached. In total there are 49 plots in one plot, 7 time points and 7 dimensions, some of the dimensions are measured in different points (a,b,c,d) then each points should have a certain color. Thank you everyoneJMP17 

  Mendes-Burak

  Discussions |

  Mar 29, 2024 9:07 AM

  1524 views | 3 replies

• New Column to show repeated values in for each run/ID across two data types

  I tried using lag function to indicate when the first test for a sample ID based on time column. Need to the column, Order Tested, to represent first test conducted for a sample ID and second test based on time. Each test will have a real and maybe a code value. See attached file for JMP file. At the end of the day Order Tested column needs to look like image below. This is just a sample, real one...

  VT23

  Discussions |

  Mar 29, 2024 8:59 AM

  1423 views | 2 replies