JMP User Community

Latest Discussions

Using Create Database Connection for a ODBC Database in JMP 17

Hello, I have a JSL script that uses the "Create Database Connection" function to connect to an ODBC database and executes an SQL query (see below). This script was working on JMP 16, however I received a new computer and upgraded to JMP 17 and now I am receiving the attached error ("Send Expects Scriptable Object in access or evaluation of 'Send', dt1 << Show WIndow(0)"). I've performed some debu...
Austin

Discussions |
Jun 15, 2023 7:20 PM

3244 views | 3 replies
Correlation plot without modifying datatable structure

I would like to do a correlation plot to compare tested parameter (Id) between TestStages for different parts as shown in the attached example data table.I want median for Id1 (for all parts) on x-axis and median for Id2 (for all parts) on y-axis with associated limits ref. lines on respective axes (i.e. LSL/USL vertical lines for TestStage 1 needed on x axis while LSL/USL horizontal lines for Tes...
Neo

Discussions |
Jun 15, 2023 12:38 PM

1397 views | 3 replies
Count number of rows in column, with matching character

Hi, I'm trying to wirte a jsl code to get a count of the number of strings(rows) with a certain specified characters at a certain position within the column.Eg. I want to get the count of the number of the rows containing sting "1" between the rows containing only three "P" charactersIn this case, the row count would be 26. Please advice. Thanks,Jackie
Jackie_

Discussions |
Jun 15, 2023 10:46 AM

2065 views | 5 replies
Add Ref Line () not working if axes names are supplied from outside.

The first case works fine but the second case where the axes names are supplied from outside does not work, where am I going wrong? Graph Builder( Size( 528, 457 ), Show Control Panel( 0 ), Variables( X( :Column (3) ), Y( :Column (4) ) ), Elements( Points( X, Y, Legend( 3 ) )), SendToReport( Dispatch( {}, "Median 1", ScaleBox, {Add Ref Line( _LSL1_, "Solid", "Black", "xLSL", 1...
Neo

Discussions |
Jun 15, 2023 10:10 AM

925 views | 1 replies
How to stack as a matrix? Or some other function to achieve this?

Hi, I am new to JMP. I have a chellenge while scripting to stack values as shown in the first table below to the values in the second table. How can I arrage this?

dateSP_topSP_BottomCoating_topCoating_bottomReading_topReading_bottomD1S1S2C1C2R1R2D2S3S4C3C4R3R4 datelocationSPCoatingReadingD1TopS1C1R1D1BottomS2C2R2D2TopS3C3R3D2BottomS4C4R4
JMP2TMW

Discussions |
Jun 15, 2023 9:09 AM

1314 views | 2 replies

Previous
Next

Latest Discussions

Using Create Database Connection for a ODBC Database in JMP 17

Hello, I have a JSL script that uses the "Create Database Connection" function to connect to an ODBC database and executes an SQL query (see below). This script was working on JMP 16, however I received a new computer and upgraded to JMP 17 and now I am receiving the attached error ("Send Expects Scriptable Object in access or evaluation of 'Send', dt1 << Show WIndow(0)"). I've performed some debu...
Austin

Discussions |
Jun 15, 2023 7:20 PM

3244 views | 3 replies
Does anyone know about TDMS format data converting into JMP?

I am trying to read data files in TDMS format by NI, with JMP to analyze.However, I cannot do this until I convert it to excel or any other format.What will I need to import such format?
joelahn

Discussions |
Jun 15, 2023 6:46 AM

3574 views | 5 replies
Script for distribution plot ( multiple column and group by row name)

Hi All, I would like to create a script for below distribution. Where should I edit in the script to have "by" grouping.And if I just want to display lot_id=lot01 how can I filter that in the script. Appreciate if anyone can help me on this. I get this script from https://community.jmp.com/t5/Discussions/Script-multiple-columns-grouped-in-distribution-plot/m-p/162798#M40093
mylifemyrule

Discussions |
Jun 15, 2023 6:39 AM

2240 views | 4 replies
Error using associative array (dictionary) // subscripted key not in map in access or evaluation

For some reason, a script that was working stopped (both in JMP 16 and 17) and now I am getting the following error subscripted key not in map in access or evaluation of 'aaa (bbb) [ccc]' , "aaa (bbb) [ccc]"I have a small script that renames the columns of a secondary table to a primary table. First, an associative array is created (not shown). Then I iterate through the columns. new_colNames = dt...
FN

Discussions |
Jun 15, 2023 6:26 AM

930 views | 1 replies
Sorting the level after analysis

I analyzed the data in a split-plot design and in the post-hoc test (LSMeans Differences Student's t) the levels by default were arranged according to the least Sq mean. I tried to sort them based on levels and for individual tables; I got success. But I want to know how we can change these settings (sort by levels) by default for all analyses.
Lalit_Rolaniya

Discussions |
Jun 15, 2023 4:41 AM

2139 views | 3 replies

Previous
Next

Latest Discussions

problème importation base oracle avec Jump

bonjour, quand j'importe une base type oracle avec Jump, j'obtiens pour certaines valeurs des caractères spéciaux; voir image.alors que dans la base de données, les cellules sont vides. est-ce que celà vient du client Oracle sur mon poste?est-ce que celà vient de la base oracle sur le serveur,est-ce que celà vient du client Jmp? cordialement
Françoise

Discussions |
Jun 12, 2023 9:12 AM

638 views | 0 replies
Combine Rule

Referring to Rules: Stepwise Regression Control Panel (jmp.com) and Example of the Combine Rule : JMP Help Could somebody please further elaborate on the 2 tests when considering the entry for a term. It would also be immensely helpful if the explanation was based on stepwise backward selection. "Calculates p-values for two separate tests when considering entry for a term that has precedents. The ...
CorpVi

Discussions |
Jun 12, 2023 2:59 AM

762 views | 0 replies
Failed to convert varchar value ro datatype int in query (query worked before but now not)

Hi , I used JMP DATAbase Query to query data from tables. the same query worked find until today it suddenly complains of issue of converting char to int. I'm not sure why it worked before and nothing has changed, but now not it is not working. So I started to work on the custom query to find a way to add script to convert. This is my first time with the custom sql query. how can I convert the t2....
dadawasozo

Discussions |
Jun 9, 2023 7:30 AM

740 views | 0 replies
Main Menu("command") - return value?

If I open a file via open("filename"), the command returns a reference to the data table which can be used as dt = open("filename");If I trigger open viadt = Main Menu("open")it doesn't return a reference to the data table. In general, is there a way, when triggering a command from the Main Menu, to get the return value?e.g. a reference to a data table for a user defined file loader - or an error ...
hogi

Discussions |
Jun 7, 2023 8:42 AM

629 views | 0 replies
Selecting multiple legend entries - how?

Sometimes in a GraphBuilder it's difficult to select multiple entries in the legend, especially along the idea:- select a first entry- press shift *)- while clicking on another entry.If everything works fine, at the end both entries plus the entries in between will be selected. But there are cases where either the first selected entry or all entries are deselected at the end.
Is there a feature beh...
hogi

Discussions |
May 24, 2023 3:08 PM

633 views | 0 replies