JMP User Community

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

847 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

4646 views | 14 replies
Countif equivalent?

I am trying to find a JMP formula function equivalent to Excel’s Countif function, that points to a column and returns the number of rows that are the same as the value in the current row, as you would get if you did a Summary on that row. In other words, if I have a 1000-line table, and column Color is set to "Purple" in 27 rows, I want a formula for a new row that returns 27 for those rows (and ...
DispersionSpark

Discussions |
Aug 22, 2024 11:30 AM

5413 views | 11 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

1784 views | 4 replies
How to change the sort order of values in a local data filter?

Hi All, I'm using JMP 18 and have a JMP file that uses a custom SQL query to create a data table. There are several dashboards (composed of graphs created in Graph Builder) attached to the data table. Some of the dashboards contain a local data filter for users to control select rows should be displayed in the associated graphs. I want to change the sort order of the values in the local data filte...
andyknc

Discussions |
Aug 22, 2024 10:10 AM

2846 views | 5 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

847 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

1784 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

1277 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
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

555 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

555 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

615 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