JMP User Community

Latest Discussions

How to use Term Values in a For Loop expressing a column name

I'm trying to cycle through columns and set value to create table later. However, "Term Value" will not allow ith substitution for each column (bolded below in the script) in the For Loop. The script just spits out the default values. What would be the correct format to assign a column in this For Loop?Thanks //Troubled Section// {Probability Paper( Profiler( 1, Confidence Interval...
Timesawasten12

Discussions |
Feb 25, 2022 2:49 PM

918 views | 1 replies
make all Bivariate plots into a column, rather than a row?

I have a single Y value and many X values I'm plotting and the resulting output is 100's of charts in a single row, needing to scroll left/right. I'm scripting it to plot the X values from a group of columns. How can I get this to display in a column instead? dtWIDE= current data table(); ERplot = Bivariate( Y( :ER_avg), X( dtWIDE<<get column group( "Step2" )), <<{Arrange in Rows( 52 ), Order...
aliegner1

Discussions |
Feb 25, 2022 8:05 AM

3864 views | 5 replies
Charts are only partially showing up as interactive HTML

I have a set of charts that I want to save as an interactive HTML, but when the charts show up as a web page part of one of the charts is blacked out. Could this be due to the chart displaying too much data? I've tried with Chrome, Firefox, and Microsoft edge and they're all having the same problem. Charts Displayed in JMP: Charts displayed as Interactive HTML:
bbass

Discussions |
Feb 25, 2022 7:06 AM

2165 views | 5 replies
Create a loop to display References Lines in a Graph

Hello all, I am using JMP15 since 1 year but I am just beginning to get interesting in scripts. I would like to write a script to display References Lines in a graph, based on a table. I have 2 tables : data (on which I run the script, to plot value=f(time)) and dates, containing one column with dates corresponding to the references lines I would like to have in the graph.Those tables are attached...
elisexx

Discussions |
Feb 25, 2022 5:05 AM

1589 views | 3 replies
referencing column using Column("name")

Hi,I have a "quick" question:dt = Open( "$Sample_data/Big Class.jmp" ); //// These don't work; dt << Select where( Column("sex") == "F"); dt << Select where( Column(3) == "F"); //// Only this works...why?? dt << Select where (:sex == "F");I am pretty sure all these options used to work for me.....has something changed? I am using JMP16.Reason I am asking is because I usually have the column name...
derchieh

Discussions |
Feb 25, 2022 4:49 AM

1465 views | 3 replies

Previous
Next

Latest Discussions

How to use Term Values in a For Loop expressing a column name

I'm trying to cycle through columns and set value to create table later. However, "Term Value" will not allow ith substitution for each column (bolded below in the script) in the For Loop. The script just spits out the default values. What would be the correct format to assign a column in this For Loop?Thanks //Troubled Section// {Probability Paper( Profiler( 1, Confidence Interval...
Timesawasten12

Discussions |
Feb 25, 2022 2:49 PM

918 views | 1 replies
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

1791 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

976 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

2252 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

1496 views | 1 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

597 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

769 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

589 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

1391 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

789 views | 0 replies