JMP User Community

Latest Discussions

Unexpected error during script

Hello, I'm writing a script to deconvolute a json file.Once in jmp, the resulting table is composed of groups of columns labelled such as study.xyz, study.cro, groups.xyz, groups.id, test.xyz, test.name,... I'm trying to create a series of tables for each of the groups such as study/groups/test.I have a script that does that well when each subset is handle separately but for some reasons it stops...
Sburel

Discussions |
Aug 2, 2020 9:56 AM

3631 views | 6 replies
Text Edit Box Inside a For Loop

Hi, I want to generate text edit boxes using a For Loop. I was wondering how could I get text from each text box and use it later (I need to use it later in a Select Where function) Here is my script. It can generate the display boxes but seems can not get the text from them. There is an error message.prefix = []; win = New Window("Start", <<Modal, <<ReturnResult, vlb = Vlistbox(), Fo...
hahahaqing

Discussions |
Jul 31, 2020 7:36 AM

1471 views | 1 replies
Finding vertex of bivariate graph

Hi all, I'm trying to get a vertex point from bivariate graph as so far, I get the extract the parameter with script and calculate it by excel sheet. I'm quite sure finding vertex function is included in JMP but I couldn't find it. Is there any way to get vertex directly? Thank you <script that I used to extract the parameter> dt = Current data Table (); biv=Bivariate( Y( :contra...
Brad_Park

Discussions |
Jul 31, 2020 1:05 AM

5173 views | 8 replies
Column formula to select column value matching other column values.

I have a table similar to the one below:I need to find the time since the 'START' step for each row. So, for each row I need to find the 'STARTTIME' value that match the 'BATCH' value and the Step as 'START' and then find the difference of that row's start time from the first start step - time stamp for that batch.Hoping to make it clearer; How do I write a column formula to do this? I am aware o...
spoikayil

Discussions |
Jul 30, 2020 5:57 PM

2704 views | 2 replies
Is there a way to write a script to that graphs 2 different types of plots in one graph?

Hi, I am fairly new to jmp and am trying to write a script to automate something I have been able to do in other software. I am not sure what I am wanting to do is possible. I am trying to use some data to overlay 2 graphs, one is a scatter plot and the other is a line graph. I am able to do the scatter plot, but cannot figure out how to include the line graph one as well. I have included some ima...
GardDog

Discussions |
Jul 30, 2020 3:41 PM

4742 views | 8 replies

Previous
Next

Latest Discussions

Text Edit Box Inside a For Loop

Hi, I want to generate text edit boxes using a For Loop. I was wondering how could I get text from each text box and use it later (I need to use it later in a Select Where function) Here is my script. It can generate the display boxes but seems can not get the text from them. There is an error message.prefix = []; win = New Window("Start", <<Modal, <<ReturnResult, vlb = Vlistbox(), Fo...
hahahaqing

Discussions |
Jul 31, 2020 7:36 AM

1471 views | 1 replies
Overlay different plot type for different data set

I want to have a scatter plot for dataset 1 and line plot for dataset 2 in a single plot or graph builder. It is more like the way we can change the plot type for different dataset in excel, when both dataset are plotted in a single graph. Any idea how to do that in graph builder
mrq

Discussions |
Jul 30, 2020 10:17 AM

2476 views | 3 replies
How to design a DOE covering 3 systems, 8 factors and 6 products resulting in one optimal setting?

I'm designing a DOE design with 7 variables that are all continuous. My expectation is 2 of these factors will probably have an optimum curve that is not linear, I also expect interactions between my variables. I have 3pc of the system I'm testing on and my system needs to be able to handle 6 different products - my problem is that I need to find one compromise in settings that provide the optima...
MiaS

Discussions |
Jul 30, 2020 10:13 AM

1366 views | 1 replies
Split plots

I am helping a colleague analyze some data, and he set up his experiment in a simple manner, but one in which I have never seen. He had reef corals in aquaria and wanted to see under which conditions they grow best. Normally, you would have many tanks, each with its own set of conditions, but he used huge tanks (to make them more "reef-like") in which conditions varied WITHIN tank. I am specifical...
abmayfield

Discussions |
Jul 30, 2020 8:23 AM

10240 views | 9 replies
I have a script, and I want to add some values to my data in a specific row and column. There are no unique values to where I could use an if statement to signify the row. Are there any other options to do this?
GardDog

Discussions |
Jul 30, 2020 6:10 AM

1181 views | 1 replies

Previous
Next

Latest Discussions

XPath Query() and XML namespaces

I have a bunch of XML documents that I want to put into a data column. I want to use XPath expressions to pull out values from them, by appending columns that contain formulas that make use of the XPath Query() function. Some of my documents have XML-namespace qualified element names. For example, one might look like this: <?xml version="1.0" encoding="UTF-8"?> <synopsis xmlns="http://www.cap.org/...
john_madden

Discussions |
Jul 23, 2020 9:53 AM

1321 views | 0 replies
Using JMP to Calculate Surface Flatness

Has anyone used JMP to calculate the Minimum Zone surface flatness of a point cloud? I have some differences between two metrology areas for our surface flatness requirements and wanted to check them in JMP. There are different algorithms for doing the calculation. (There is an ASME standard for the general rule, ASME Y14.5: " a tolerance zone defined by two parallel planes within which the surfa...
jay_holavarri

Discussions |
Jul 20, 2020 11:26 AM

1571 views | 0 replies
Save all scripts and close reports by JSL

Trying to write a script for this I found the following below working. JMP15@Win10.The first part opens two tables and starts some Reports,and the second Closes all report Windows post saving scripts to belonging tables.But when the report has a local datafilter, the script is not working any more (get scriptable object doesn't get the Right reference).Is there a way to find proper reference for e...
Georg

Discussions |
Jul 20, 2020 7:48 AM

1317 views | 0 replies
[JSL Contour Plot] Method of define contour plot, number, minimum, maximum

The contour plot is very helpful to show 3D map, however the problem of defining the zone is always a trouble. In my typical jsl plot, I use something below to define the contour plot zone number = 8, maximum = 1.4, minimum =1. However, the table column :Length may change time to time, and the scale will have to be modified manually for each corresponding plot. Does someone have experience how t...
Stokes

Discussions |
Jun 25, 2020 12:09 PM

1197 views | 0 replies
Impact of screen resolution on html output

Hi, I'm preparing a dashboard using jmp that will be used for a daily meeting. It contains information in form of data tables and text boxes. In order to transfer text sizes and colors for the text as well as the data tables into the html output I transformed them into pictures (rep = dt << get as report(); pic = rep << get picture(); ). I set up all font sizes on my external monitor and it worked...
Ole

Discussions |
Jun 9, 2020 6:21 AM

1180 views | 0 replies