Welcome to the JMP User Community!

Latest Discussions

• Joining tables with different significant digits

  I am trying to join a DOE table created Jmp with a table created in an external program and imported into Jmp.  I've figured out that if I expand the format to 16 decimals that the data does not match. For example, the initial value used when creating the DOE table was something like 1.2, the DOE table value to 16 decimals is  1.2000...002, and the imported data is 1.2000...000.   Is there a way t...

  mfoster

  Discussions |

  Dec 6, 2021 2:11 PM

  2166 views | 5 replies

• 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

  1842 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

  2387 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

  1470 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

  3159 views | 7 replies