JMP User Community

Latest Discussions

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

1749 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

2297 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

3355 views | 10 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

839 views | 1 replies
JMP equivalent of Excel's COUNTIF function

I'm trying to mimic this Excel-type behavior: AB1failureTypenumFailuresThisType2f1=countif($a$2:$a$999,a2)3f2=countif($a$2:$a$999,a3)4f1=countif($a$2:$a$999,a4)5f1=countif($a$2:$a$999,a5)6f2=countif($a$2:$a$999,a6)......... ... in JMP. Is this possible as a column formula? I've tried "Col Sum( :failureType == :failureType[ Row() ] )" but that doesn't work and I don't understand why. Sometimes "...
BHarris

Discussions |
Aug 22, 2024 1:06 PM

4597 views | 14 replies

Previous
Next

Latest Discussions

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

839 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

1773 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

1274 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

747 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

550 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

747 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

550 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

553 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

610 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

522 views | 0 replies