Welcome to the JMP User Community!

Latest Discussions

• 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

  2338 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

  1428 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

  3117 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

  1083 views | 1 replies

• How to get nonlinear fit parameters back to data table

  Hi,I have used the nonlinear platform interactively to fit and estimate the parameters Max and k in a formula column as below. I would like to get the estimates back to the data table to use in other formula columns. I have searched, but not been able to figure out how to access them outside the column where the formula resides. I tried Save estimates to table, which gets them into a new separate ...

  Ake

  Discussions |

  Dec 3, 2021 9:42 AM

  2043 views | 4 replies