JMP User Community

Latest Discussions

Concatenate values in a column

Seems like this should be simple, but I cannot find a clear example. I would like to concatinate the values in columns of a specific name("ROW" and "COL") and create a new column with the result in it. Example below. ROW COL CELL5 1 5_13 2 3_212 -1 12_-1 best shot at code so far: column("ROW") << Data type(Character); column("COL") << Data type(Character); //a = {column("ROW"), column("COL")}; ...
ladomiqo

Discussions |
Feb 24, 2022 2:11 PM

1829 views | 5 replies
How to show only significant correlation (>= .6) in a large correlation matrix

I have 33 Likert scale variables that measure different types of disabilities from facial expression to speech, etc. The total score across all 33 scores gives a good index of an overall disability level. However, I found out that some items are highly correlated and perhaps redundant. I ran a correlation matrix for the 33 items in JMP Pro 16 that produced a huge table with the majority of correla...
helalmob

Discussions |
Feb 24, 2022 1:44 PM

2842 views | 3 replies
Simple start for script

Hi I am a bit embarrased that I get stuck on this simple task. It is a simple task: I have 2 data-tables (dt-1 and dt-2). I want to step through the first and for each row compare a value with a value in the second table, starting with first row in that table. If it is close enough I will collect a value from that dt-2 and save in a field in dt-1, put a special marker in a field in dt-2 so I kno...
gueriniere

Discussions |
Feb 24, 2022 11:11 AM

1806 views | 3 replies
How do I add a time stamp when printing a data table?

I want to add a time stamp to a print of my data table. I know how to add the date with the &d; option in Page Setup. Is there a way to also add the time?
StefanC

Discussions |
Feb 24, 2022 9:18 AM

1074 views | 1 replies
Adding constraints to design with discrete factors

Hello,I am trying to add constraints to design with 4 discrete factors (X1,X2,X3,X4), where all the factors have 3 levels. What is the best way to add constraint to specify that three factors (X2,X3,X4) should add up to 97%? I am assuming I'll have to add disallowed combinations script option for this but not sure about the script.
billi

Discussions |
Feb 24, 2022 8:36 AM

1004 views | 2 replies

Previous
Next

Latest Discussions

Concatenate values in a column

Seems like this should be simple, but I cannot find a clear example. I would like to concatinate the values in columns of a specific name("ROW" and "COL") and create a new column with the result in it. Example below. ROW COL CELL5 1 5_13 2 3_212 -1 12_-1 best shot at code so far: column("ROW") << Data type(Character); column("COL") << Data type(Character); //a = {column("ROW"), column("COL")}; ...
ladomiqo

Discussions |
Feb 24, 2022 2:11 PM

1829 views | 5 replies
Adding constraints to design with discrete factors

Hello,I am trying to add constraints to design with 4 discrete factors (X1,X2,X3,X4), where all the factors have 3 levels. What is the best way to add constraint to specify that three factors (X2,X3,X4) should add up to 97%? I am assuming I'll have to add disallowed combinations script option for this but not sure about the script.
billi

Discussions |
Feb 24, 2022 8:36 AM

1004 views | 2 replies
MSA Gauge R&R AIAG Version?

Hallo!JMP Verion 16.1Vorrede zu meinen Daten:Ich möchte einen Datensatz (2 nahezu gleiche Messysteme, darauf jeweils die 10 gleichen Personen mit 5 Wiederholungen gemessen) auswerten und den Varianzanteil durch die verscheidnen Massysteme zu erhalten. Dazu kann ich ja Gauge R&R oder EMP zur Analyse verwenden. Da alles mit dem gleichen Bediener gemessen wurde, würde ich bei der Analyse die 2 Messys...
CountableMarten

Discussions |
Feb 24, 2022 8:23 AM

2311 views | 4 replies
How to set values for last 30 rows of a column?

Hi guys, I'm a complete scripting newbie here so please have patience with me . I have a data set with multiple columns and am trying to make a script that will automatically select the last 30 rows of a column and change the content from "baseline" to "CLCR". Please see my attempt: dt = Current Data Table(); dt1 = dt << Select Columns( :CLCR ); dt1 << select where( Row() > N Rows( dt ) - 30 ); d...
kkrog

Discussions |
Feb 24, 2022 1:07 AM

1528 views | 1 replies
Conditional If then to return values for ranges

I have written a formula to flag runs in campaigns (ex: consecutive days above 19.) HOw can I create a formula that will then generate the production values specific for campaigns greater than 9 days? (Examples: campaign 1, 2, 3=>No value whereas campaigns showing 1,2,3,4,5,6,7,8,9 would show the appropriate number 19,20,21,22,23,24,25,26,27 etc.)
ByrdQuestions

Discussions |
Feb 23, 2022 3:11 PM

1485 views | 2 replies

Previous
Next

Latest Discussions

No table linking after saving the project?

Hi,when I generate a summary table with the option "link to original data table" (selected by default), the two tables are linked:By selecting a row in the summary table the corresponding rows in the original table are selected.Cool.This also works for selections in Graphs and Dashboards.Very cool! Now my problem:After saving both tables to a project file, (precisely: after close & re-open the pro...
hogi

Discussions |
Feb 3, 2022 4:19 AM

619 views | 0 replies
Setting Guardbands on Test Limits Using EMP

Hello. I am trying to use the EMP tool to help set guardbands to my test limits based on my gauge R and R data from a final test machine.I used 10 devices and measured these devices 5 times each, across 5 different test sites on the machine.I need to know how much to guardband my Upper and Lower specs. I am having trouble understanding how to apply the data in the EMP report. I feel like this is a...
Jbritsch04

Discussions |
Feb 2, 2022 8:49 AM

800 views | 0 replies
How to introduce lower bounds for simulated data in Profiler platform

Hi JMP community, (JMP Pro 16.0.0) I'm hoping to find out if there is a way to include lower bounds to simulated data in the Profiler platform. I have several predictors going into a model, but few data points to fit. So, in order to generate simulated ("synthetic") data, I use the Prediction Profiler platform along with the multivariate correlation structure of the data to generate thousands ...
SDF1

Discussions |
Feb 1, 2022 11:09 AM

610 views | 0 replies
Query Builder filtering on date stored in Varchar(20)

Query Builder - date filter.SQL ServerJMP version 16.2In the database (SQL Server) I get the Date field called RETURNDATE in ‘varchar20’ – I would like to use the Calendar functionality in the filter to select my dates I tried to create a calculated column (Calc1) and specify CAST([RETURNDATE] as date), which he doesn’t like. Using SQL outside Query BuilderSELECT TOP (1000) [LABJOBNO] ,[DESPA...
HansD

Discussions |
Jan 25, 2022 6:12 AM

1416 views | 0 replies
M1 Macbook Pro JMP Capabilities

Hi all,
I'm thinking about upgrading from my windows set-up and running a M1 Macbook Pro as my primary set up. I wanted to open up the discussion and see if any other JMP users were using the newest Macbook Pro and if they have run into any hurdles yet? I do a lot of R/Python integration. I do have a decent set up right now, but want to know if anyone else has tested out this connection and knows ...
MikeDereviankin

Discussions |
Jan 21, 2022 1:52 PM

815 views | 0 replies