JMP User Community

Latest Discussions

Problem extracting eigen value data from PCA report when using 'by'

Hello, I running a PCA on a data table independently for several categories (specimen_material_type).For each category, I want to save the eigenvalues of principal components into an eigenvalue data table labelled 'Eigenvalue for XYZ'. In the example table, I have 2 categories. I manage to retrieve the first set of values using a For loop but then it crashes for the second category. Any suggestion...
Sburel

Discussions |
Jun 30, 2021 12:12 PM

1485 views | 2 replies
Issues in running a R Script from JSL

This is my script: Names Default To Here( 1 ); R Init(); x = R Submit File("C:/Users/adhil/Documents/JMP/Test Program Validation/Jun 2021 Test Program Release Validation/compile.r"); df = R Get(main_df) R Term(); this is the R Script I intend to run library(dplyr) setwd("~/JMP/HPLED Validation/Jun 2021 HPLED Release Validation") new_tProgram_data <- "./data/A05/data_01.blu" por_tProgram_data <- ...
Adhil71186

Discussions |
Jun 30, 2021 10:11 AM

1811 views | 3 replies
Section 508 compliance

Is there any guidance on how to make JMP graphs section 508 compliant (ADA issue for government documents)? I found a post on how to remove the gray background, but is there any 508 specific guidance or other preference settings that would be helpful? Maybe this is a wish list item?
GGfGA

Discussions |
Jun 30, 2021 10:03 AM

1087 views | 0 replies
How do I concatenate variable column name with a string?

This is what I have: for ( k = 1, k < selColumn, k++, ColumnName = selColumnNames[k]; dt << New Column( dt:ColumnName ); ); This what I want:for ( k = 1, k < selColumn, k++, ColumnName = selColumnNames[k]; dt << New Column( dt:ColumnName || "Mean" ); );selColumnNames is a list of all the column names in my table.
Muhu

Discussions |
Jun 30, 2021 3:38 AM

2093 views | 1 replies
Moving header down into row 1

Hello, My raw csv file is in a weird format, causing the first data point I need to be imported as the header, which is not what I want. So I created a new, blank row at the top, and am trying to figure out how I can pull the column name into the blank row before renaming the header? Any help is appreciated!names default to here(1); dt=current data table(); For (i=1, i<=2, i++, Row(1)[i] = Char(...
dlemieu1

Discussions |
Jun 29, 2021 1:45 PM

5920 views | 6 replies

Previous
Next

Latest Discussions

Issues in running a R Script from JSL

This is my script: Names Default To Here( 1 ); R Init(); x = R Submit File("C:/Users/adhil/Documents/JMP/Test Program Validation/Jun 2021 Test Program Release Validation/compile.r"); df = R Get(main_df) R Term(); this is the R Script I intend to run library(dplyr) setwd("~/JMP/HPLED Validation/Jun 2021 HPLED Release Validation") new_tProgram_data <- "./data/A05/data_01.blu" por_tProgram_data <- ...
Adhil71186

Discussions |
Jun 30, 2021 10:11 AM

1811 views | 3 replies
Section 508 compliance

Is there any guidance on how to make JMP graphs section 508 compliant (ADA issue for government documents)? I found a post on how to remove the gray background, but is there any 508 specific guidance or other preference settings that would be helpful? Maybe this is a wish list item?
GGfGA

Discussions |
Jun 30, 2021 10:03 AM

1087 views | 0 replies
Reordering Column Not Working

Hello,
The reorder columns function doesn't work in the column menu. Does anyone know a reason for this? Is this due to the data type or name?

MikeDereviankin

Discussions |
Jun 29, 2021 10:58 AM

1169 views | 1 replies
How to look for optimal conditions with two responses : one to maximize and the second lower than USL

Hello, In Monte Carlo simulations, how to set your desirability when you have 2 responses : Y1 to maximize and Y2 lower than USL. The objective is to look for optimal conditions with low defect rate (<2%) Thanks I
JMPdiscoverer

Discussions |
Jun 29, 2021 9:52 AM

1442 views | 1 replies
Paired T-Test with 3 Processes and Multiple Response

Hi Everybody, I ran an experiment where the goal was to compare whether three separate processes produced similar results. I made 6 different products (with different specifications) on each of the three processes (6 products x 3 processes = 18 total). Additionally, I have at least two different responses I want to compare the output of. I am almost certain this data is paired, but I don't know i...
tnorthen

Discussions |
Jun 29, 2021 7:24 AM

4636 views | 4 replies

Previous
Next

Latest Discussions

Section 508 compliance

Is there any guidance on how to make JMP graphs section 508 compliant (ADA issue for government documents)? I found a post on how to remove the gray background, but is there any 508 specific guidance or other preference settings that would be helpful? Maybe this is a wish list item?
GGfGA

Discussions |
Jun 30, 2021 10:03 AM

1087 views | 0 replies
Multi File Import of network folder slower in latest JMP version

Hello, In JMP 14, Multi File Import of a network folder was relatively fast. For example, it takes ~11 seconds to load the below folder. With JMP 16 on the same computer/folder/network, it will first spend almost 3 minutes while "discovering files", before proceeding with the above "loading file names" step. Are there any settings or options that I could change to skip the "discovering files" step...
jach

Discussions |
Jun 22, 2021 11:06 AM

966 views | 0 replies
ODBC Hive connection, change container size in the script?

Wondering if anyone can help here. I am trying to write some JMP scripts that SQL query data from a hive table. I need to change the container size and am told that I should just "do it in the connection settings". I was told that in python, you just add a configuration={"hive.tez.container.size":'10240'} parameter to the hive.connect call. How would I do this through JMP? I already have the Cloud...
aliegner1

Discussions |
Jun 17, 2021 3:43 PM

1194 views | 0 replies
Using a List to Filter in Custom Query Builder - Question

Hello, I would like to use a list to filter within a continuous column in Query Builder. Range and then join does not work as my data set from my database will be tens of millions of lines, so I would like my list to be the only thing queried. I would like to use a list (I have a separate data sheet with the column) of about 40 or so unique numerical values and use that in the filter for a custom ...
Benjamin_S

Discussions |
Jun 3, 2021 7:59 AM

1498 views | 0 replies
Can I control text size in a word cloud inside a dashboard container?

Hi all,I have a dashboard with a data filter, a map, and a word cloud that looks like image 1 below. I have two formatting issues with the word cloud I'd like to fix. First, by design, when I make different selections using the data filter, the subset of records that are shown in the map changes and the word cloud applies only to that selection. However, when I change the data filter selection, th...
caseylott

Discussions |
Apr 28, 2021 12:03 PM

1486 views | 0 replies