JMP User Community

Latest Discussions

Setting data table left panel size in JSL?

I have a script which generates a data table and adds new scripts so the user can do additional analysis and data modification. The problem is that the script names are relatively long and get truncated by the size of the left panel when the new table is created. I know I can set the size and position of the table with JSL, but is there a way to set the left panel size? I thought that maybe H S...
Joe_T

Discussions |
Aug 23, 2024 8:28 AM

8742 views | 8 replies
How do I get the value of the R-Sq, L1, L2 and lambda out of Elastic Net Regression platform so I can compare models?

I am comparing different parameter settings for some elastic net regression models on a smallish data set to demonstrate at what point datasets are too small for regression methods and want to compare between JMP, SAS, R and Python. Although I can set the alpha, I can't see how to directly output the lambda, L1 and L2 values that are used in the chosen models and the resulting R-Sq for the model. ...
gemmahodgson

Discussions |
Aug 23, 2024 2:37 AM

1301 views | 2 replies
interaction between two data tables

i have two data tables, data table A is the source file, data table B is the subset of A and went through table -> split in JMP.Both data table A & B consist of unique number under column name called UNIQUE. Can i interactively move from one row to next row in data table B & get the corresponding row in data table A highlighted or selected, meaning data table A & B linked together using unique col...
CumulativeMean2

Discussions |
Aug 23, 2024 1:29 AM

1754 views | 6 replies
JSL for importing spec limits

I am writing a JSL code to import specification limits from a separate data table into the main data table. // Open the Spec Limits table specTable = Open("C:\Trending Tool Spec Limits.jmp"); // Open data table for analysis dataTable = Data Table( "Trending data" ); // Extract Spec Limits and Show Limits from Spec Table For Each Row( specName = specTable:Variable[]; LSL = specTable:LSL[...
Steffen_Bugge

Discussions |
Aug 22, 2024 11:49 PM

2303 views | 7 replies
Interval, different in JMP, LOGICALLY SHOULD BE SAME.

Hi.I faced a problem and appologize in advance that it might be a foolish question.make simple, the situation is, Data ist={0,3,6,9,12}y1={y11,y12,y13,y14,y15}y2={y21,y22,y23,y24,y25}y3={y31,....}where y1,y2,y3 are the Batch number (Lot number)So, there should be 3 respective regression line. I tested the line comparability and the conclusion was "Different Slope and Different Intercept" Thus, I p...
MikeKim

Discussions |
Aug 22, 2024 10:54 PM

3367 views | 10 replies

Previous
Next

Latest Discussions

How do I get the value of the R-Sq, L1, L2 and lambda out of Elastic Net Regression platform so I can compare models?

I am comparing different parameter settings for some elastic net regression models on a smallish data set to demonstrate at what point datasets are too small for regression methods and want to compare between JMP, SAS, R and Python. Although I can set the alpha, I can't see how to directly output the lambda, L1 and L2 values that are used in the chosen models and the resulting R-Sq for the model. ...
gemmahodgson

Discussions |
Aug 23, 2024 2:37 AM

1301 views | 2 replies
select all the excluded cols, then delete?

I'm working with a script that's doing some big data analysis on dt's with 10k+ cols. some of my first passes for screening these features results in excluding ~90% of the cols for further deeper analysis. In the interest of tidying up and reducing the dt, I want to select all the excluded cols and delete them. Any tips on how to script this? In my script, I am generating a colsList that is the 'k...
TriangularLlama

Discussions |
Aug 22, 2024 5:26 PM

846 views | 1 replies
Looking for a formula to find the "elbow" in my data

Hi JMP friends,(On regular JMP 18.0.1, example data attached) I am analyzing some data wherein I need to find the time (x point) at which my data has an "elbow" or inflection. I have an initial mini-peak in my data and have been doing this work manually. However, this is slow and I would like to automate it, as I will be doing this for hundreds of tests that return graphs similar to the below, wi...
RZordich

Discussions |
Aug 22, 2024 10:37 AM

1780 views | 4 replies
Multi File Import Change Output Name

I know this has been asked before, but I followed that solution and I cannot make it work. I am trying to import multiple files using MFI (which I can do), but it defaults to its own output table name. How do I change that output name (both scripting and where in the script)? Using JMP 17. <JSL> // Import multiple files Multiple File Import( <<Set Folder( "C:\Users\bfkhp\OneDrive - grifols.com...
patriciafm811

Discussions |
Aug 22, 2024 9:41 AM

1276 views | 3 replies
Machine data source list remove in "Database Operations"

I used "File"-->Database-->Open table-->New connection to setup some tables from DB. but I found my list for new connections becomes longer and longer. like the attached pic. I did not found there is a way that i can remove any items from the connection list. the question is that is there a way that i can delete them. Thanks in advanced. KRSean
Sean_ShCn0

Discussions |
Aug 22, 2024 7:24 AM

748 views | 0 replies

Previous
Next

Latest Discussions

Machine data source list remove in "Database Operations"

I used "File"-->Database-->Open table-->New connection to setup some tables from DB. but I found my list for new connections becomes longer and longer. like the attached pic. I did not found there is a way that i can remove any items from the connection list. the question is that is there a way that i can delete them. Thanks in advanced. KRSean
Sean_ShCn0

Discussions |
Aug 22, 2024 7:24 AM

748 views | 0 replies
Write Data from Data Table to Database

Hello JMP-Community,I am searching your help here because I didn't found a sufficent solution for myself in other posts. It is about writing content of a data table into a table of a database.For that I wrote this little function: myInsertInto = function({dt, dbConnection, destinationName}, cols = dt << GetColumnNames(String); rows = dt << Select All Rows << GetSelectedRows; show(cols, rows);...
DBo_94

Discussions |
Aug 22, 2024 6:38 AM

554 views | 0 replies
Is there a way to tell LCA that the rows are ordered by class?

Typical dataset: 120-200 rows, 15 classes. Rows are known to be ordered by class. What is unknown is where the 'fences' between classes are. As-is -- i.e., without taking row order into account -- LCA correctly classifies about 94% of rows. My intuition is that if I knew how to tell the algorithm that the rows are grouped by class on input, we'd be at 100%. Visual, in case my use of 'grouped by' i...
mtowle419

Discussions |
Aug 15, 2024 5:03 PM

555 views | 0 replies
latin hyper cube

Hi there,

I am attempting to run latin hyper cube with three continuous and one categorical factors, but the option is not available except for fast flexible filing design; can anyone assist me with this? thanks in advance
H6Habib

Discussions |
Aug 14, 2024 1:58 PM

612 views | 0 replies
Characters as Markers: How to get rid of the shadows?

I like the ability to add outlines to data points. This is very useful for separating partially overlapping data points.Unfortunately, when characters are used as markers, the outline mode looks very unprofessional - kind of like shadows, but without blur.Besides turning off the outline mode - is there a way to get rid of the "shadows"? (view in My Videos) Names Default to Here(1); dt = Open( "$S...
hogi

Discussions |
Aug 9, 2024 3:04 AM

524 views | 0 replies