Welcome to the JMP User Community!

Latest Discussions

• "Import Multiple files" function with different column numbers

  I am using "Import Multiple files" function to combine multiple .CSV file in to JMP table. As Some of my files has different number of columns it is opening individuals JMP table, not combine. How can I merge multiple .CSV file with different number of column.  This is a simplified data I have. First few columns are time and serial numbers but after that i have repeated measurement of the SN. No o...

  ConfidenceOwl94

  Discussions |

  Oct 15, 2024 9:08 AM

  458 views | 2 replies

• How can I initialize my data wrt a fixed value?

  Hi, I would like to implement a formula to “initialize” some data in our tables. Specifically, I would like to subtract from all elements in a column the value of the first repetition of the test run ( the repetition info is contained in another column).
  I attach the table I am working on. The formula would be integrated in Column “X_35”. The idea is to assign to each test the value contained in X_...

  Matteo_Rotti

  Discussions |

  Oct 15, 2024 8:25 AM

  941 views | 5 replies

• Script to select to generate an options menu to select columns and rows based on multiple parameters.

  I have been trying to teach myself JSL and after going back through the Introduction to the JMP Scripting Language again, I rediscovered the "Make Specific Report" script which allows for the selection of a specific date range (row selection) and Die temperatures (column selection) from the "Process data" data table. I have been trying to make a similar script and apply it to some stability data a...

  QCSci_CK

  Discussions |

  Oct 15, 2024 8:13 AM

  313 views | 1 replies

• Collision in SQL Select-statement between special escape characters (bracket and backslash) and bracket in column name with quotation marks around it

  I'm running into a problem with an SQL Select-statement using column names that are including brackets, because the end brackets of the column names end up next to backslashes (due to using quotation marks within quotation marks: " \!" column name [ units ] \!" " ) and this interferes with the surrounding special escape characters (bracket and backslash: \[ ]\ ). The SQL-statement is written betwe...

  Dape

  Discussions |

  Oct 15, 2024 7:44 AM

  973 views | 8 replies

• Automate copying table scripts when rerunning "source"

  Hi,I am creating a database in Excel that will be continually updated. New rows and columns will be added periodically, and existing rows will occasionally have new data added. As such I have started making use of the "Source" script to update the corresponding downstream JMP table.The question I have is, is there a way to bring over any existing table scripts to the updated table when running the...

  sowiakg

  Discussions |

  Oct 15, 2024 7:20 AM

  911 views | 4 replies