Welcome to the JMP User Community!

Latest Discussions

• Replace multiple rows value from one column is not working properly

  Hi JMP community, I have occured one issue that quite weird. Here's my code:dt_temp = data table("aaaa"); dt_temp << Summary( Group( :Column1,:Column2), Freq( "None" ), Weight( "None" ),output table name( "summary" ) ); data table("summary") << select where (:N rows >= 2 & !contains(:Column1,"AA") & !contains(:Column1,"BB") ); rows = dt_temp << get selected rows; dt_temp:Column3[rows] = ""; //C...

  nthai

  Discussions |

  Jun 5, 2021 10:35 AM

  3563 views | 7 replies

• Process Capability study doesnt display all parameters from Stdf file

  i have a stdf file and when doing process capability study. for some reasons  some parameters are missing. Any idea how to  fix it? 

  steo45

  Discussions |

  Jun 3, 2021 2:48 PM

  2628 views | 5 replies

• Concatenate columns with empty cells

  Hi all,I have a dataset with different columns that have some empty random cells (like the example in the table below). I would like to concatenate the values of the different columns and use the "_" to separate the content of the cells only if the content of the cells is different from empty value (as in column "concat" below). Does anyone have a suggestion on a how to to this operation in a smar...

  JMP_fan

  Discussions |

  Jun 3, 2021 9:02 AM

  2257 views | 3 replies

• Update from Database on a Timed Frequency

  Hello,I currently have a script that requires user input to define variables that are used to query a database and generate control charts. To eliminate the need for an operator to provide these inputs again to generate the control charts whenever new data is in the database, I would like to automatically update the control chart on a timed frequency. For example: 1. User provides input.2. Initial...

  Austin

  Discussions |

  Jun 2, 2021 9:23 AM

  1183 views | 1 replies

• Saving JMP File / data table in Sharepoint through JSL

  I'm trying to store a jmp data table which I can periodically update through JSL script (e.g. treating it like a check-in, check-out log).  So far, I was able to successfully open the data table using the Open() function. However, instead of opening the actual data table, it downloaded like a temporary copy of the table from sharepoint as I see that the table name became "Untitled $$$".  This is s...

  Djtjhin

  Discussions |

  Jun 1, 2021 8:12 PM

  3494 views | 3 replies