JMP User Community

Latest Discussions

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

1430 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

3520 views | 6 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

688 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

830 views | 1 replies
Color Histograms with By statement in Distribution

I am trying to use distribution to create histograms By(: DeviceID), However when I apply the fill color only the last graph in the By statement gets changed to light blue. No matter what I do, only the last graph changes color. I just want the graphs to not be green.Options that work for me:1) color histograms by device ID2) color histograms both to be blue WaferRgPastMonth << Distribution( Stac...
saneal

Discussions |
Jun 29, 2021 9:09 AM

985 views | 2 replies

Previous
Next

Latest Discussions

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

688 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

830 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

2365 views | 4 replies
Normalize data Columns for PCA

I am being asked to normalize sensor data with respect to one of my columns before I run a PCA. It was mentioned that there was a checkbox or something to do this in JMP. Is that true? Or do I need to do it manually column by column. Any help would be great!
jmpnewbie1

Discussions |
Jun 29, 2021 7:16 AM

1284 views | 1 replies
coding data into treatments

I have raw data of about 3550 data points and need to code this data into four different treatments. Any help on how to go about this?
Samboat

Discussions |
Jun 29, 2021 1:22 AM

658 views | 1 replies

Previous
Next

Latest Discussions

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

580 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

760 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

1073 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

1007 views | 0 replies
多重比較での生存曲線の書き方　Bonferroniなど

4群での生存曲線をJMPproでの書き方を教えて下さい。また、JMPで「環境設定グループ」から「レポート」を選択し、「ローカルデータフィルター」を出せればできる方法も紹介されていたのですが、「ローカルデータフィルター」を出せません。どの方法でもよいので、JMPProで、多重比較法を用いた生存曲線の書き方をどなたか教えてください！宜しくお願い致します。
27070

Discussions |
Apr 20, 2021 1:41 AM

1957 views | 0 replies