JMP User Community

Latest Discussions

SQL command limit in query builder?

In normal SQL, I can limit the number of returned results using the function LIMIT. Is there a similar function in the Query Builder available?When querying large data bases, it would be nice if I could limit the number of results to avoid overloading JMP when selecting the filters unwisely.
Feli

Discussions |
Jun 17, 2021 10:47 PM

1986 views | 2 replies
Overlay a graph onto another graph

Folks, What are the ways (or best way) to overlay another graph onto another as shown in first attachment? Final objective is to generate multiple plots, arrange them in a window that is saved as a table property. This table property is then run so the final composite picture is able to be copied and pasted to Powerpoint. The script I have so far almost gets me there (see attached script and 2nd a...
NRW

Discussions |
Jun 17, 2021 7:19 PM

3006 views | 4 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

974 views | 0 replies
How to make a validation column in regular JMP using JSL?

Hi I think there is a "Make Validation Column" function in JMP pro but I am wondering how to make a validation column (with 25% training and 75% validation) using JSL in regular JMP? Any help is appreciated.
shasheminassab

Discussions |
Jun 17, 2021 2:35 PM

1573 views | 2 replies
How to select a subset of a data table given a subset of rows

Hi this should be fairly simple to knock out.How do I select a subset of a data table, all columns, given a subset of its rows?I didn't see anything about this in the scripting index, neither in select where nor in subset. But apologies if it's obviously found somewhere. I just didn't find it. Mike
mostarr

Discussions |
Jun 17, 2021 2:34 PM

2632 views | 3 replies

Previous
Next

Latest Discussions

SQL command limit in query builder?

In normal SQL, I can limit the number of returned results using the function LIMIT. Is there a similar function in the Query Builder available?When querying large data bases, it would be nice if I could limit the number of results to avoid overloading JMP when selecting the filters unwisely.
Feli

Discussions |
Jun 17, 2021 10:47 PM

1986 views | 2 replies
Overlay a graph onto another graph

Folks, What are the ways (or best way) to overlay another graph onto another as shown in first attachment? Final objective is to generate multiple plots, arrange them in a window that is saved as a table property. This table property is then run so the final composite picture is able to be copied and pasted to Powerpoint. The script I have so far almost gets me there (see attached script and 2nd a...
NRW

Discussions |
Jun 17, 2021 7:19 PM

3006 views | 4 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

974 views | 0 replies
How to make a validation column in regular JMP using JSL?

Hi I think there is a "Make Validation Column" function in JMP pro but I am wondering how to make a validation column (with 25% training and 75% validation) using JSL in regular JMP? Any help is appreciated.
shasheminassab

Discussions |
Jun 17, 2021 2:35 PM

1573 views | 2 replies
Please email me the link to download "Semiconductor Toolkit_JMP14-15.jmpaddin" and the Semiconductor Toolkit_JMP14-15.jmpaddin script.

Hi Mike, I am not able to download the Semiconductor Toolkit_JMP14-15.jmpaddin JSL. It may have something to do with the security Fire Wall. Would you please email the Semiconductor Toolkit_JMP14-15.jmpaddin JSL to me at john.wang@ngc.com. Thanks,John Wang@MikeD_Anderson
johnj_wang1

Discussions |
Jun 17, 2021 10:10 AM

1249 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

974 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

1279 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

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

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

Discussions |
Apr 20, 2021 1:41 AM

2279 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

971 views | 0 replies