Welcome to the JMP User Community!

Latest Discussions

• Looking for tips for rapid conversion of string to matrix

  I have data that I retrieve from a database which is in a pipe-delimited string format. For example "70|71|69|78". These strings represent numeric measurements.A large number of measurements are made and the resulting strings are really long. On top of that I have a large dataset of these strings.What I need to do is convert the strings to a matrix ( vector really ) and run some aggregating statis...

  tsl

  Discussions |

  Feb 17, 2023 11:33 AM

  2884 views | 10 replies

• Cell comparison with conditional output

  Hi, I'm trying to create a count of occurrences based on conditions, using the table below as an example. The conditions for a count of 1 are that columns "Parameter" AND "Location" both repeat together in the next row OR anywhere else in the 2 columns. The output table would have the same column data present in the original table with 3 added columns of "Count" , "Tool 1", "Tool 2" (number of too...

  jmper99

  Discussions |

  Feb 17, 2023 11:20 AM

  2201 views | 8 replies

• Scripting automation: Retrieving predictors & setting sigma level

  Hello, I was given a project to script a modeling flow. All predictors and responses are numeric continuous & responses are fit separately. After some initial data prep...Stepwise K-fold validation <-- AutomatedStep 1's model run in SLS <-- AutomatedSLS prediction profiler:Initialize Simulator <-- AutomatedChange all factor types to random <-- Not automated
  Change all SD's to 3 sigma value for each...

  StarfruitBob

  Discussions |

  Feb 17, 2023 11:14 AM

  1863 views | 7 replies

• Curves in Dashboards: send to front?

  When data points are selected, they are automatically highlighted in other graphs - and sent to front.The same also works in Dashboards that are saved as html files.
  
  Now I noticed that for curves the "send to front" just works in jmp - but not in the html Dashboard.Is there a way to enable it or the html file as well?  

  hogi

  Discussions |

  Feb 17, 2023 10:46 AM

  750 views | 2 replies

• How to hide and exclude cells instead of change to missing in jsl after explore outliers?

  I am scripting Explore Outliers in jsl and it works great with k sigma algorithm. However the script I got from this jmp community changes the outliers to missing but how do I set them to hide and exclude instead?dt1 = Current Data Table(); eo = dt1 << Explore Outliers( Y( :var1 ), K Sigma( 2 ), Robust Fit Outliers, Where( :x == 1 ), Invisible ); eoRep = Report(eo); table = eoRep[TableBox(...

  FrequencyBison9

  Discussions |

  Feb 17, 2023 9:55 AM

  1268 views | 2 replies