JMP User Community

Latest Discussions

joining tables while averaging across columns with the same name

I have what would appear to be an easy-to-fix problem, but for the life of me, I can't figure out how to do it easily. I have three separate tables in which the rows are individual proteins. The "accession" refers to their names. Some proteins are found in multiple tables, whereas some are only found in one of the three. I know how to join the tables by matching the protein names (accession=access...
abmayfield

Discussions |
Jun 22, 2021 10:09 AM

1212 views | 2 replies
Numerical Variable Not Evaluating in List

I am trying to Write() a list with a number variable i inside of it like thisWrite({i});but it prints, literally, {i}, not {1} or {2} or whatever the variable number of i is.i is most certainly defined and assigned because goingWrite(i);works.What am I doing wrong?
mostarr

Discussions |
Jun 22, 2021 10:09 AM

1186 views | 2 replies
Is there a way to reference the current column name in a formula?

Hi - I'd like to be able to reference the name of a column in a data table to which a formula has been applied, in much the same way that the row() function returns the current row. I want to be able to do it so that I can copy the column properties of a single column of one data table to multiple columns of another data table with a different set of names (which I don't know in advance, but which...
DMR

Discussions |
Jun 22, 2021 9:23 AM

900 views | 1 replies
JSL: How to get the nice ROW LEGEND colors without the row legend?

So here's a question. I'm trying to script the formatting of a fresh data table and Fit YbyX but hitting a roadblock on the RowLegen and coloring. Selecting "Row Legend" automatically colors the points and the source data table appropriately and adds the legend.The problem I'm running into is that the Quantiles plot creates it's own legend that I can't seem to turn off, and it does not actually ...
aliegner1

Discussions |
Jun 22, 2021 8:47 AM

1884 views | 1 replies
Questions for the process capability (Analyze - Quality & Process - Process capability)

Hi Super usersI would like to ask some questions for the process capability (Analyze - Quality & Process - Process capability) I have made an summary report & have 2 questions during the process 1. Why should I set alpha level (Significance level)? What does this value mean here? What does it impact for the result?Actually I changed the value, but cannot find the result changed2. I could see colo...
Dan2

Discussions |
Jun 22, 2021 5:09 AM

1192 views | 2 replies

Previous
Next

Latest Discussions

joining tables while averaging across columns with the same name

I have what would appear to be an easy-to-fix problem, but for the life of me, I can't figure out how to do it easily. I have three separate tables in which the rows are individual proteins. The "accession" refers to their names. Some proteins are found in multiple tables, whereas some are only found in one of the three. I know how to join the tables by matching the protein names (accession=access...
abmayfield

Discussions |
Jun 22, 2021 10:09 AM

1212 views | 2 replies
Is there a way to reference the current column name in a formula?

Hi - I'd like to be able to reference the name of a column in a data table to which a formula has been applied, in much the same way that the row() function returns the current row. I want to be able to do it so that I can copy the column properties of a single column of one data table to multiple columns of another data table with a different set of names (which I don't know in advance, but which...
DMR

Discussions |
Jun 22, 2021 9:23 AM

900 views | 1 replies
JSL: How to get the nice ROW LEGEND colors without the row legend?

So here's a question. I'm trying to script the formatting of a fresh data table and Fit YbyX but hitting a roadblock on the RowLegen and coloring. Selecting "Row Legend" automatically colors the points and the source data table appropriately and adds the legend.The problem I'm running into is that the Quantiles plot creates it's own legend that I can't seem to turn off, and it does not actually ...
aliegner1

Discussions |
Jun 22, 2021 8:47 AM

1884 views | 1 replies
Questions for the process capability (Analyze - Quality & Process - Process capability)

Hi Super usersI would like to ask some questions for the process capability (Analyze - Quality & Process - Process capability) I have made an summary report & have 2 questions during the process 1. Why should I set alpha level (Significance level)? What does this value mean here? What does it impact for the result?Actually I changed the value, but cannot find the result changed2. I could see colo...
Dan2

Discussions |
Jun 22, 2021 5:09 AM

1192 views | 2 replies
Virtual Join

I am trying to connect multiple tables via Virtual Join for which Timestamp is the Reference key.The main table has 2021-01-03 09:30:01 time stamp format where the column is nominal.2 other tables which had the same "time stamp" format has been joined. I need to join the 4th and 5th Table with Time stamp in Numeric format as shown here 3/10/2021 16:45Note- I do not have "second (from Timestamp) :0...
SymS

Discussions |
Jun 21, 2021 10:10 PM

901 views | 1 replies

Previous
Next

Latest Discussions

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

988 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

1290 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

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

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

Discussions |
Apr 20, 2021 1:41 AM

2299 views | 0 replies
Fantasy Baseball League

I am in a 16 team fantasy baseball league. Each week we tabulate totals for home runs, batting average, stolen bases, wins, saves, era, etc. If my team has the most home runs, I win that category for the week. We track 10 statistics so after each week I may have a final score of 6-3-1. My question is how can I use JMP to check what my score would have been if I had played each of the other 14 team...
atlas100

Discussions |
Apr 19, 2021 1:29 PM

979 views | 0 replies