Welcome to the JMP User Community!

Latest Discussions

• How can I add (copy) rows according to number in a specific column to the datatable

  Hi, I have a datatable as shown below. The column Anzahl shows the counts of column Prüfplan. I want JMP to make a row for every count so that Anzahl is always 1. I did that manually for row 1 as shown below, to clarify what I want to do. The original row has to be removed of course.  Can anybody help me, thank you!

  Christina

  Discussions |

  Feb 7, 2023 8:28 AM

  2160 views | 5 replies

• How to Disconnect from a database via script?

  Hello,I am using the File>Database>Query Builder method to connect to an excel file and create a table. I am able to close the table with jmp script but the connection remains active and locks up the excel file for other users. How can I disconnect via jmp script? I can manually go through File>Database>Open>Disconnect but I would like to do this automatically in the running script. Here is the qu...

  MBRackliffe

  Discussions |

  Feb 7, 2023 7:15 AM

  1552 views | 2 replies

• Using Char to compare numeric and character values

  Hi,Is it possible to compare numeric and character values? I want to compare two columns (identical or different values). One column has a numeric date and one has a character date and as I need to compare only parts of it I want to use substring. The below script runs, but it doesn´t get me the correct result as all appears to be different (which is not the case). Am I using Char wrong? If( Subst...

  JulieSAppel

  Discussions |

  Feb 7, 2023 4:58 AM

  3665 views | 8 replies

• Authenticate DBC user and pass before storing them for future use

  Hi,I am writing some code to pull data from an ODBC connection. I want to test if the username and password entered are valid. The script is as follows: dbc = Create Database Connection("Driver={Oracle in instantclient11_1}; DBQ=" || target || "; UID=" || user || ";PWD=" || pass || ";FBS=12800000;");I found some solutions suggesting checking if dbc is empty to see if the connection was created as ...

  SivaSubram5313

  Discussions |

  Feb 7, 2023 4:52 AM

  1323 views | 2 replies

• Bad RMSE for Validation data

  HiUsing "Fit Model" I have created a model to identify moisture content in a product using different process parameters. The model is fine (Rsq=0.97) and a fairly low RMSE. The variables used all have Logworth higher than the limit.  The problem arises when I want to take in new data for validation. Here the prediction is very bad. The data that I want to validate is not very different from the da...

  AAYH

  Discussions |

  Feb 7, 2023 3:27 AM

  3135 views | 6 replies