Welcome to the JMP User Community!

Latest Discussions

• What to do if my discriminant analysis has large misclassified number & percent?

  I have done Manova for my data analysis and found significant differences among my treatments but when I run separate univariate tests and try to find where the difference is; the results were non-significant… Some other forums said that the overall variables in MNOVA may contribute to the differences among the groups ( Overall effect of all the variables), but independently the variables may not ...

  Hopexu114

  Discussions |

  Feb 7, 2023 8:38 AM

  1436 views | 1 replies

• 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

  3666 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