JMP User Community

Latest Discussions

Jmp drops decimals when importing scientific or percentage number format for Excel

When importing an Excel table with scientific or percentage formatting, Jmp drops decimals that are not displayed in the format. When formatted as a number - or even a fraction, all decimals are imported correctly.Also, importing dates does not work when the date format is in dd-mm-yyyy format and Jmp finds a date in the first row that could fit into the mm-dd-yyyy format. Jmp simply delete all da...
thomasz

Discussions |
May 19, 2021 8:11 AM

8241 views | 4 replies
Join/Update Table Function Help

Hello! I am trying to execute a join (or an update) with columns that are referenced as a variable through a Parse(Eval( "String")) command either internal or external to the join command. I have multiple columns that I aim to match by but only the first set of matches is executing. See syntax below: colNamething1 = Eval Insert( ":name(\!"^thing1^\!" )" ); colNamething2 = Eval Insert( ":name...
zrhelm17

Discussions |
May 19, 2021 7:49 AM

1678 views | 2 replies
How can JMP 16 be set so that these two phenomena do not occur?

After I use JMP 16 (Win10 64-bit), the following phenomenon did not appear in the previous version:
1: open the JMP file containing JSL security warning, can not find the Settings to cancel the warning.
2: In the case of already open JMP file, and then directly click in the Explorer to open JMP file.JMP will restart a new JMP. Exe window to open the new JMP file.Also did not find the same JMP window...
lwx228

Discussions |
May 19, 2021 7:24 AM

1351 views | 2 replies
DoE custom designs - include factors that are mutually exclusive

Hi JMP community. I just started my DoE journey on JMP recently. Sorry if I am missing anything obvious here. I am trying to work out a DOE design of a biological process that have 4-5 factors. Factor A, B and C are mutually exclusive e.g. if factor A is present then B and C are not, vice versa. I have found a previous discussion here in the community Defining Factor Constraints in Custom D...
modelcitizen89

Discussions |
May 19, 2021 5:51 AM

2947 views | 4 replies
Ignoring "Excluded" rows

Hello, I'm still trying to get over the JSL "hump," so forgive the fundamental question.The issue:- I have a sample table that contains data sets for three replicates with sample suffix a1, a2, and a3.- At times, one of the replicates needs to be set to the "Excluded" state (example below is a2)- I'm writing a batch script that will open a table and apply calculations only sets that were not exclu...
NRW

Discussions |
May 19, 2021 5:31 AM

2955 views | 5 replies

Previous
Next

Latest Discussions

How can JMP 16 be set so that these two phenomena do not occur?

After I use JMP 16 (Win10 64-bit), the following phenomenon did not appear in the previous version:
1: open the JMP file containing JSL security warning, can not find the Settings to cancel the warning.
2: In the case of already open JMP file, and then directly click in the Explorer to open JMP file.JMP will restart a new JMP. Exe window to open the new JMP file.Also did not find the same JMP window...
lwx228

Discussions |
May 19, 2021 7:24 AM

1351 views | 2 replies
Ignoring "Excluded" rows

Hello, I'm still trying to get over the JSL "hump," so forgive the fundamental question.The issue:- I have a sample table that contains data sets for three replicates with sample suffix a1, a2, and a3.- At times, one of the replicates needs to be set to the "Excluded" state (example below is a2)- I'm writing a batch script that will open a table and apply calculations only sets that were not exclu...
NRW

Discussions |
May 19, 2021 5:31 AM

2955 views | 5 replies
Constrained variables query

Hi,Can anyone advise a simple way to indicate that either a factor or an effect is constrained within limits ? Examples would include numbers expressed as %'s which must therefore lie between 0 & 100, such as Purity or the Yield of a reaction. This would be especially useful if it can be applied to a data table column, for example, rather than needing to be built into a custom design, thus enabl...
NickT

Discussions |
May 18, 2021 11:54 PM

1729 views | 4 replies
Handling maintenance schedules in repairable systems simulation (RSS)

Hi all, I didn't find a particular topic that addressed this so I was hoping to get some help from some of you folks that use RSS. Basically there's two things I'm trying to do in the simulation engine to account for real-life response for maintenance cycles:1) If I have two parallel components, both of which have failures and scheduled items, I would like to be able to suspend the scheduled item ...
Norman

Discussions |
May 18, 2021 5:03 PM

1162 views | 1 replies
JMP import Excel from columns that are not continuous

My example here is: I have an excel table currently with 50 columns and is continuously growing. I only want to import first 4 column and last 5 column at any time. How do I achieve that with JMP script.
aaronjiang

Discussions |
May 18, 2021 1:41 PM

985 views | 1 replies

Previous
Next

Latest Discussions

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
多重比較での生存曲線の書き方　Bonferroniなど

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

Discussions |
Apr 20, 2021 1:41 AM

2270 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

968 views | 0 replies
Generation of overdispersed poisson count data (vs gamma poisson)

Hello, I would like to reconcile the parametrization used in the Random Gamma Poisson(lambda, sigma)with the over-dispersion parameter as estimated in generalized linear model platform. Take for instance the attached table. Here the generating function is Random Gamma Poisson(exp(1+3*:X1),10)Running glm with poisson/log + overdispersion I obtain: Overdispersion = 6.09. Is there any way to link...
matteo_patelmo

Discussions |
Apr 12, 2021 9:53 AM

1178 views | 0 replies
JSL Syntax Change is coming: Name() is being deprecated

Hi All, I just read here that the JSL syntax for referencing a column using the Name() parser is going away. The new syntax is currently in use and at some point the old syntax will be removed entirely. There's a lot of people here who script, so thought it would be good to post something here. I know I have a lot of code I'll need to change! Better to be ahead of the curve and change it befor...
SDF1

Discussions |
Apr 7, 2021 10:14 AM

884 views | 0 replies