Welcome to the JMP User Community!

Latest Discussions

• need jsl script help - trying to remove random rows for model validation testing and use the remainder of rows for model creation

  Hi - I am trying to fit a regression equation using a random 80% of data and, using the resulting modeled equation, run the remaining 20% of data through the model and save the observed versus modeled results of those 20%.  That is, the 20% of rows are used for validation.    My dataset has 227 rows.  I want to train (i.e. develop a regression equation) using 80% of those after which that regressi...

  learning_JSL

  Discussions |

  Mar 21, 2025 11:32 AM

  527 views | 8 replies

• Automatically plot the associated columns in an Associative Array

  With a lot of help from Jarmo, I got an Associative Array (aa) of columns that are linked.  Next, I need to plot those, is that easily done   Names Default To Here(1); startchar1 = "VT"; startchar2 = "ID"; rgx_startchar1 = Eval Insert("^startchar1^(.+?)$"); dt = Current Data Table(); collist = dt << get column names(string); VT_IDcols = {}; For( i = 1, i <= N Items( collist ), i++, If( !Cont...

  SpannerHead

  Discussions |

  Mar 21, 2025 11:30 AM

  227 views | 2 replies

• JMP 18 not importing Excel data with correct data type

  I recently upgraded to JMP 18 and am encountering issues with scripts I developed in JMP 16 for importing Excel files. Specifically, JMP 18 is not recognizing data types correctly when importing tables: - Many columns with characters in every row are being imported as numeric.
   - Numeric columns (with no missing data) are being imported as character.
  I noticed that the Excel Import Wizard allows man...

  swelish

  Discussions |

  Mar 21, 2025 10:16 AM

  781 views | 7 replies

• STDF files

  HelloI have an STDF file and if I understood well JMP works just with a CSV filethere is any option to convert or upload an STDF file to JMP and work with it?I see there are any scripts to run it, but it's very difficult for me to work with them.

  Dennisbur1

  Discussions |

  Mar 21, 2025 9:49 AM

  5701 views | 8 replies

• Randomize rows from a datatable

  Hi dear Community,   I have searched the Community for this question but was not able to find an answer.   Due to specific objectives, I created a DoE using first a D-Optimal approach (24 rows) and then augmenting it with Space-Filling augmentation (adding 16 rows). The problem I'm facing is that rows are not randomized for the entire design, you can clearly see the initial rows are from D-Optimal...

  Victor_G

  Discussions |

  Mar 21, 2025 9:24 AM

  525 views | 5 replies