JMP User Community

Latest Discussions

SPLIT from tall to wide: how to group the resulting columns dynamically?

So I've got a large dt that I'm splitting from TALL to WIDE. This results in a huge qty of columns, all with the header format = "Step#_Parameter_Function".The amount of these columns vary and are never predictable and set, nor are the step #'s or names. How would i be able to then group these columns by Step#? Some sort of loop to scan through the long list of columns, pick out the first Step# an...
aliegner1

Discussions |
Jun 30, 2021 5:31 PM

1710 views | 3 replies
Script: How to send a group of columns to selection on FitYbyX?

Wondering if this is possible. I have a bunch of columns I've grouped together and want to standardize a script that will send all the columns in a group to the Yresponse. Each instance of this data table will have a variable amount of columns and the names will be changing and not fixed. I'd love to just say: Send this group to the Yresponse.
aliegner1

Discussions |
Jun 30, 2021 4:39 PM

1439 views | 3 replies
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

1105 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

1387 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

880 views | 0 replies

Previous
Next

Latest Discussions

Script: How to send a group of columns to selection on FitYbyX?

Wondering if this is possible. I have a bunch of columns I've grouped together and want to standardize a script that will send all the columns in a group to the Yresponse. Each instance of this data table will have a variable amount of columns and the names will be changing and not fixed. I'd love to just say: Send this group to the Yresponse.
aliegner1

Discussions |
Jun 30, 2021 4:39 PM

1439 views | 3 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

1387 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

880 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

911 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

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

880 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

733 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

973 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

1275 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

1264 views | 0 replies