Welcome to the JMP User Community!

Latest Discussions

• 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

  1559 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

  3675 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

  1326 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

  3138 views | 6 replies

• formula not automatically evaluated until clicking apply button

  Hello. I made a script adding a column with a conditional formula , the output resulted to a null column only until you click apply in the column formula, I want to automatically output it , I asked colleague to try my data and script , it worked with them. what could be the problem with my jmp16.new column("Remarks01",character,nominal,formula(If( :Remarsk00 == "Y",     "1_a",     "2_b" ))); 

  sos012523

  Discussions |

  Feb 6, 2023 11:57 PM

  1247 views | 2 replies