JMP User Community

Latest Discussions

How to save results from SQL query in data table?

Hello Everybody,I have the following issue. I want to execute SQL query to get data from database and that is working well. After that I would to save data from query in data table and use that for further processing. Based on ideas from other posts I did a simple assignment to the new variable dt_TestData. I am providing as argument for Data Table the name taken from QueryName. However an error o...
lukasz

Discussions |
Jun 16, 2023 3:58 AM

7234 views | 5 replies
Significance testing on standard deviations

Hi there, I have 30 samples measured using two methods (Method A and Method B) and each sample has been measured 5 times. I have summarised my dataset so I have the mean and standard deviation for each sample on the two methods. I want to compare the within-sample variability between Method A and Method B, matched by sample. Is it ok to perform a paired t-test (or non-parametric equivalent) on the...
Alicia

Discussions |
Jun 15, 2023 11:54 PM

2326 views | 3 replies
Workflow builder error for Custom Action (Error: Send Expects Scriptable Object)

I added the JSL below as Custom Action in the Workflow builder. The error happened at the For loop (Error: Send Expects Scriptable Object).While running this script in Script window, it works properly to rename columns header that contain "%, ". Any idea on how to solve this to make the workflow more smooth? else, need to stop at this step to run Column Renaming script outside the WorkFlow Builder...
Nita_Natchanok

Discussions |
Jun 15, 2023 10:32 PM

2390 views | 6 replies
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

3301 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

1429 views | 3 replies

Previous
Next

Latest Discussions

How to save results from SQL query in data table?

Hello Everybody,I have the following issue. I want to execute SQL query to get data from database and that is working well. After that I would to save data from query in data table and use that for further processing. Based on ideas from other posts I did a simple assignment to the new variable dt_TestData. I am providing as argument for Data Table the name taken from QueryName. However an error o...
lukasz

Discussions |
Jun 16, 2023 3:58 AM

7234 views | 5 replies
Significance testing on standard deviations

Hi there, I have 30 samples measured using two methods (Method A and Method B) and each sample has been measured 5 times. I have summarised my dataset so I have the mean and standard deviation for each sample on the two methods. I want to compare the within-sample variability between Method A and Method B, matched by sample. Is it ok to perform a paired t-test (or non-parametric equivalent) on the...
Alicia

Discussions |
Jun 15, 2023 11:54 PM

2326 views | 3 replies
Workflow builder error for Custom Action (Error: Send Expects Scriptable Object)

I added the JSL below as Custom Action in the Workflow builder. The error happened at the For loop (Error: Send Expects Scriptable Object).While running this script in Script window, it works properly to rename columns header that contain "%, ". Any idea on how to solve this to make the workflow more smooth? else, need to stop at this step to run Column Renaming script outside the WorkFlow Builder...
Nita_Natchanok

Discussions |
Jun 15, 2023 10:32 PM

2390 views | 6 replies
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

3301 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

3623 views | 5 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

653 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

776 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

753 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

645 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

652 views | 0 replies