Welcome to the JMP User Community!

Latest Discussions

• How to update table script

  What is the most reliable way of updating table script? Let's say I have a script that saves a snippet of a script into a table as table script and gives it a name "Script". Let's say, I run that script again and it again saves an updated snippet as table script - it will add " 2" to "Script" since that name already exists.If I then want to run the script by name it will run the old one, with name...

  miguello

  Discussions |

  Dec 6, 2021 5:15 AM

  1816 views | 2 replies

• Is it possible to execute a script by clicking a curve in the graph via JSL?

  For example, I made a graph of the script below.dt = Open( "$SAMPLE_DATA/Students2.JMP" ); dt << Sort( By( 1 ), Order( Ascending ), replacetable( 1 ) ); New Column( "A" ); Column( "A" ) << Formula( If( Row() == 1 | name != Lag( name, 1 ), 1, If( Lag( A, 1 ) < 6, Lag( A, 1 ) + 1 ) ) ); dt << run formulas; Column( "A" ) << deleteFormula; dt << Sort( By( "A" ), Order( DEscending ), replacetable( 1 ) ...

  lwx228

  Discussions |

  Dec 6, 2021 3:18 AM

  2342 views | 7 replies

• How I can separate number and character in cell in JMP

  Hi ,I have question about JMP , I have column with numbers (0) and letters so I need to create new column and using formula include only the letters and delete all (0) ! so is it possible to do that in JMP ? and which function I should use ?I tried (word) function but it does not work with me! Here the column :and I want something like this : Thanks

  Balqees

  Discussions |

  Dec 5, 2021 8:28 AM

  1430 views | 2 replies

• Formatting Asian dates to short dates

  Many companies in Asia type their dates different from that in USA. For example, 3rd Dec. 2021, Asian companies will type it as 03/12/2021 but in USA we type it as 12/03/2021. I have a table which I parse out the dates and convert it into short dates. But the circle ones are wrong, see below image. I used the code below. How do I let JMP know that the dates extracted from the Text column are in th...

  cchueng

  Discussions |

  Dec 4, 2021 4:41 AM

  3119 views | 7 replies

• Interpolation contour map: Based on Z1( x1, y1), Z2( x2,y2), to interpolate Z3(x3,y3)

  Jmp has a contour map to use certain algorithm to interpolate results, based on Z1( x1, y1), Z2( x2,y2) to calculate Z3 (x3,y3). For example below 3 column, if we know the x,y, and its corresponding height, how can we calculate the height at (2,2)?Is there a script for doing this type of interpolation? Thanks X, Y, Height1,1, 101,2,321,3, 132,1,232,2, ??2,3, 443,1,233,2,113,3,42

  Stokes

  Discussions |

  Dec 3, 2021 4:13 PM

  1087 views | 1 replies