JMP User Community

Latest Discussions

Referencing columns from other tables

I'm trying to make a new table by reading from two source tables. I'd like to avoid joining them into one big table and manipulating from there. The new table will be an array of deltas between the two source tables. The script is creating the columns just fine, but it's not populating them with anything. I'm assuming there's some syntax i'm missing in referencing columns from other tables in ...
bwkeller2

Discussions |
Jul 24, 2020 7:47 AM

5017 views | 7 replies
JMP 15 date time format changes

Hi,I upgraded to JMP15 recently and found that some of my scripts written in JMP14 did not work properly. I found that this line did not work because of an unrecognized format:New Column( "Date", Numeric, "Continuous", Format( "d/m/y h:m:s", 22, 0 ), Input Format( "d/m/y h:m:s", 0 ) ), When I changed it to read:New Column( "Date", Numeric, "Continuous", Format( "d-m-y h:m:s", 22, 0 ), Input Forma...
Onjai

Discussions |
Jul 24, 2020 6:24 AM

6918 views | 7 replies
How to remove summary statistics using JSL Part 3

Hello Community, I had asked a related question to this yesterday and got great answers. However, I ran into problems when trying to implement the solution. After spending countless hours, I am asking for more help. Here is the scenario. I have a data table (attached) with the following columns and rows: 1. I would like to loop through each column at a time starting from column "fruit" and plot a...
simon_2

Discussions |
Jul 23, 2020 8:42 PM

3663 views | 6 replies
How to make Col List Box Report only specific data type

try to make a column list box so the user can select parameters for analysis. Want to limit to column with data type "character" in this col list box. Use the script below but it report all columns. nw = new window("Select Parameter for Pareto", borderbox(left(3),top (2), hlist box( textBox("Select Group for Yield Analaysis"), hlistbox( vlistbox( panelbox("Select group", C...
yanee

Discussions |
Jul 23, 2020 6:21 PM

2676 views | 3 replies
Screening Outliers

Hello, I have some data that has outliers. I was able to find them using Explore Outliers. I selected only 1 column of data and another categorical one to group by. I used the Quantile Range Outliers command, and one outlier was detected. I'd like to color or select that cell. When I choose one of the options, I get a JMP Alert: "Select a column or columns before clicking this button". How ...
natalie_

Discussions |
Jul 23, 2020 1:10 PM

2130 views | 2 replies

Previous
Next

Latest Discussions

Referencing columns from other tables

I'm trying to make a new table by reading from two source tables. I'd like to avoid joining them into one big table and manipulating from there. The new table will be an array of deltas between the two source tables. The script is creating the columns just fine, but it's not populating them with anything. I'm assuming there's some syntax i'm missing in referencing columns from other tables in ...
bwkeller2

Discussions |
Jul 24, 2020 7:47 AM

5017 views | 7 replies
How to make Col List Box Report only specific data type

try to make a column list box so the user can select parameters for analysis. Want to limit to column with data type "character" in this col list box. Use the script below but it report all columns. nw = new window("Select Parameter for Pareto", borderbox(left(3),top (2), hlist box( textBox("Select Group for Yield Analaysis"), hlistbox( vlistbox( panelbox("Select group", C...
yanee

Discussions |
Jul 23, 2020 6:21 PM

2676 views | 3 replies
Screening Outliers

Hello, I have some data that has outliers. I was able to find them using Explore Outliers. I selected only 1 column of data and another categorical one to group by. I used the Quantile Range Outliers command, and one outlier was detected. I'd like to color or select that cell. When I choose one of the options, I get a JMP Alert: "Select a column or columns before clicking this button". How ...
natalie_

Discussions |
Jul 23, 2020 1:10 PM

2130 views | 2 replies
DSD question on Blocking at 4 blocks vs 3 blocks

Hi,Designed a DSD experiment with 5 factors in JMP15. Can only run 4 conditions at a time. So added 4 blocks with center runs to estimate quadratic effects. Expected a design with 4 conditions per block and a total of 16 conditions. Instead, block 1 & 2 have 5 conditions, and block 3 & 4 have three conditions. Tried to repeat or play around the setting still cannot get 4 conditions per block....
mng1

Discussions |
Jul 23, 2020 1:05 PM

2078 views | 2 replies
Column Custom Formula

I would like to add a new column 'Vth' in my table with the following calculation:-First I need to find the index i of column 'Id' where the 'Id' is nearest to 1e-6; and then Vth = Vg(i). It should be grouped by Mod and Device columns as well. That is, each unique combination of Mod and Device will have one Vth value. IdVgModDeviceVth2.00E-0631AX1 2.00E-072.81AX1 2.00E-082.61AX1 2.00E-092.41AX1 2....
pankajsync

Discussions |
Jul 23, 2020 12:57 PM

2467 views | 3 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

1543 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

1731 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

1455 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

1325 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

1346 views | 0 replies