Welcome to the JMP User Community!

Latest Discussions

• Multiple file import Excel hidden row

  Hello, I am using JMP 18 and I need to import multiple excel files.
  As different users applied different filters I add this command to import even filtered rows from all excel files. 
  <<Set Excel Suppress Hidden Rows( 1 ), However the filtered data are not imported. Is there a difference on how JMP or excel handle hidden vs filtered rows? Is there another command I should use? Many thanks for your h...

  mgerusdurand

  Discussions |

  Oct 21, 2024 12:15 AM

  2607 views | 6 replies

• List of Strings

  To create a matrix of N identical numbers, I can use J(N, 1, number).What is the shortest (syntax) and fastest way to create a list of N identical strings?

  hogi

  Discussions |

  Oct 20, 2024 11:44 PM

  1554 views | 7 replies

• JSL - Check box to select variable to then plot in graph builder

  Hi everyone, I am trying to make a script which would work this way:1. Opens a new window showing "Select the parameters you want to plot" with a list of parameters with check box for each, and the operator would chose which ones he wants to plot by ticking them.2. Then for the ones that are ticked, open a graph builder with the corresponding variables. I am currently able to make the first step (...

  Elofar

  Discussions |

  Oct 20, 2024 5:15 PM

  9475 views | 15 replies

• Update a table with another table based on "Nearest Match" columns

  Hello, I have 2 tables (Table1 and Table2), both queried from databases.I need to update Table1 with Table2 by matching columns (:match). The problem is: - I get :match content for Table1 with a Regex from the database with (sometimes) this format: “XXXX-YY-ZZZ”.- I get :match content for Table2 from another database with a different but consistent format: “XXXXYYZZZ”. I can manually use If() and ...

  Voizingu

  Discussions |

  Oct 20, 2024 12:30 PM

  1692 views | 6 replies

• Dynamic Coding Problem

  Hello,
  
  Looking for tips on how to make my script more dynamic.
  
  Given the snippet below we have a data table << Get as Report that we add onto a Col Box() with dynamic buttons.
  
  Now, here lies the issue. I need to put X amount of data tables into my window and I'm not sure how to go about it since I also need to add dynamic buttons to each table. The exact amount of data tables can vary. Thanks for the...

  aharro

  Discussions |

  Oct 19, 2024 5:00 PM

  819 views | 3 replies