Welcome to the JMP User Community!

Latest Discussions

• Get unique column values & use them for filtering / cleaning up in a different table

  Hi, what would be the approach for using, for example, the keys in an array for selecting or filtering rows with the same keys, but in a different JMP table. I have two tables. One of them maps sample IDs for chemical testing to different factor settings (temperature, time, study nr., etc.). I am successfully getting the sample IDs in an array. (Sorry, I'm a total newbie to this.)smplID = Associat...

  Ressel

  Discussions |

  Nov 14, 2021 11:38 PM

  2274 views | 4 replies

• How to open this JSON file as a data table?

  I need help with opening this JSON file in JMP as a data table: https://www.purpleair.com/data.json I used JMP's JSON Import Wizard, but have not been able to open the file in a way that I want to.I'd like the 'fields' to be the column headers and 'data' to be the rows in the data table. I appreciate your help in advance.

  shasheminassab1

  Discussions |

  Nov 14, 2021 12:55 AM

  1546 views | 3 replies

• JMP > JSL > Script Acceleration for Multiple Call to Fit Model (N > 2000)?

  Hi JMP Community, The size of my datasets is getting bigger and the basic scripts I created a while back (see below) are not keeping up from a speed point of view. I would greatly appreciate hearing about ideas on how to optimize this type of script for better speed. For example, I suspect that operations like "Concatenate" are relatively slow, and it might make sense to work with matrices for thi...

  Thierry_S

  Discussions |

  Nov 13, 2021 1:49 PM

  2061 views | 7 replies

• Help with DOE analysis - Mixing Study

  Hello all, I am fairly new to DOE and would appreciate some assistance with the analysis of my data, especially with the correct approach and order to the analysis. I have created a simple mixing design. On the face of it, this is a very simple experiment, which involves mixing three different components to create a composite, conducting some experiments and measuring several outputs. The design i...

  Matthew_Sharp

  Discussions |

  Nov 13, 2021 3:39 AM

  967 views | 3 replies

• Summary Table For Multiple Variables

  I have a dataset fundamentally similar to the table below on the left. I need to summarize it to look like the table on the right, calculating the % of lines for each entry in the completed column for each shift for each time period. In a practical sense, a shift completed 2 red and 1 green during FM1, so the summary would need to find the % of red and green found by a shift during FM1... etc. It ...

  TFranke

  Discussions |

  Nov 13, 2021 2:57 AM

  1142 views | 1 replies