Welcome to the JMP User Community!

Latest Discussions

• GroupColumns raising exception in v18

  Dear Community, Since I moved to v18, a function call that previously worked fine, now raises an exception (in Debug mode only, otherwise, just skipped silently):This worked in v17:colList = dt2 << Get Column Names( String ); dt2 << GroupColumns( colList[1] :: :Time At Exit );Raises this exception in v18
  FYI, this explicit workaround works:
  dt2 << GroupColumns( :Time At Entrance Queue :: :Time At Ex...

  HubP-SDe

  Discussions |

  Mar 17, 2025 9:06 AM

  491 views | 1 replies

• Choosing to exclude from 2 equal outliers in DoE

  Hi, Is there any other metric I can use to help determine which outlier is more likely the true outlier in the dataset? I performed a DoE, and during the modeling, noticed that there are two equal outliers (By Externally studentized residuals: 48 & -48). If I exclude one or the other, the model's adj R2 immediately and majorly improves from around 0.65 to 0.99, and the other outlier is now found t...

  MetaLizard62080

  Discussions |

  Mar 17, 2025 9:04 AM

  637 views | 2 replies

• Categorise Columns by initials

  I'm trying to list available categories of columns based on the first 3 letters of the column title.  I can list all the available values readily but I have many duplicates.  Summarize doesn't obviously work for anything but a list of columns and what I have is a list of initials.  I tried this with no luck.  Any help appreciated. dt = Current Data Table(); dt << Clear Column Selection(); colList...

  SpannerHead

  Discussions |

  Mar 17, 2025 8:25 AM

  636 views | 2 replies

• Set column formula dynamically with JSL

  I'm working on a JSL script where I need to dynamically build a formula for a given column inside a loop. The idea is to reference a different column for each iteration, so that the formula uses the evaluated column name (e.g., :col_name) rather than inserting the literal code. Here's a simplified version of what I'm trying to achieve in the loop (I have tried many variations of Expr, Eval, Parse ...

  CSkjodt

  Discussions |

  Mar 17, 2025 7:49 AM

  978 views | 3 replies

• Stack side by side tables from excel and add header columns

  I have been struggling for 2 days pulling data from excel into JMP in the correct format. I have hundreds of excel sheets, but the data is disorganised. There are many tables next to eachother (hundreds) in an excel sheet.I want to stack the data across the different tables, but also make new columns with the associated header data. I have only been able to achieve this on one table, but can't rep...

  LK2

  Discussions |

  Mar 17, 2025 6:21 AM

  1353 views | 5 replies