JMP User Community

Latest Discussions

Custom Column formula

I would like to add a new column 'Vth' in my table with the following calculation:-First I need to find the index i of column 'IDS' where the 'IDS' is nearest to 1e-9 (or Log10[IDS] = -9); and then Vth = VGS(i). It should be grouped by Site, Measurement, SWP, Wafer columns as well. That is, each unique combination of Site, Measurement, SWP, Wafer will have one Vth value.If the IDS is not exactly 1...
pankajsync

Discussions |
Jul 1, 2021 7:39 AM

4091 views | 8 replies
Semiconductor WAT contour

How to achieve multi-group X batch drawing when drawing WAT contour: The contour platform stipulates that X only can be selected two columns, but I have multiple sets of X that need to match one Y
Jony

Discussions |
Jul 1, 2021 4:51 AM

2094 views | 5 replies
Change x axis of a hotelling T2 from sample to a date time sequence

How do I replace the x-axis of a multivariate control chart? Default it shows sample number
MarcP

Discussions |
Jul 1, 2021 2:58 AM

2223 views | 5 replies
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

1708 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

1438 views | 3 replies

Previous
Next

Latest Discussions

Custom Column formula

I would like to add a new column 'Vth' in my table with the following calculation:-First I need to find the index i of column 'IDS' where the 'IDS' is nearest to 1e-9 (or Log10[IDS] = -9); and then Vth = VGS(i). It should be grouped by Site, Measurement, SWP, Wafer columns as well. That is, each unique combination of Site, Measurement, SWP, Wafer will have one Vth value.If the IDS is not exactly 1...
pankajsync

Discussions |
Jul 1, 2021 7:39 AM

4091 views | 8 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

1438 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

1385 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

875 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

908 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

875 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

731 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

971 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

1273 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