JMP User Community

Latest Discussions

Scripting - formulas are recorded, but not other steps such as "creating and renaming new columns".

Hi,I am quite new to JMP and have tested the scripting function. I want the script to do following:1. Import an excel document2. Create and rename new columns3. Assign formulas to the columns I start by clearing the log file and then proceed with steps 1-3, but somehow only step 3 is recorded and can be saved as a script. I am greatful for any suggestions about how to move forward (preferably an i...
carolinesanden

Discussions |
Jul 7, 2021 5:30 AM

580 views | 1 replies
Find string in column, rename the column and add new column in JSL

Hi All, I have a table like below and want to find the String "Z", "A" and "B" in the columns and rename it to "Z_A" and "Z_B".After that, I want to add a column after X_loc and Y_loc which converts them to mm. The formula that I want to use is (X_Loc / 1000).Can anyone guide me on how to do the scripting for this?Thanks
achid03

Discussions |
Jul 7, 2021 5:10 AM

1077 views | 1 replies
How to make prediction profiler interactive for PowerPoint

Is there a way to make the prediction profiler interactive on a PowerPoint slide? I was seeing things online about saving it as a Flash object but I'm not sure Flash is around anymore and that will work. Thanks in advance for the help
ericx

Discussions |
Jul 7, 2021 3:51 AM

4431 views | 6 replies
Regression with a multivariate linear mixed model - Am I doing this right? and how to I extract parameter estimates and their standard errors?

I have been working on a multivariate linear mixed regression analysis in JMP and would like to check in to determine: QUESTION 1. whether or not I am on the right track? Data collected for the analysis described below stems from a field experiment possessing a randomized complete block design, with 4 replications. The experiment has an additive design, in which crop density is elevated incrementa...
mmccollough18

Discussions |
Jul 7, 2021 2:09 AM

2432 views | 6 replies
How to make a calculus in JMP

How to make a calculus in JMP? There is a two dimension of data, for instance, current and time, then in JMP Grapher, we can plot a curve and fit it smooth, for detail, please see photo below.How much electric quantity will be? that means I'd like to know how to calculate the area under the curve?in mathmatic , how to make a calculus in JMP?
mujahida

Discussions |
Jul 6, 2021 3:25 PM

8176 views | 3 replies

Previous
Next

Latest Discussions

Scripting - formulas are recorded, but not other steps such as "creating and renaming new columns".

Hi,I am quite new to JMP and have tested the scripting function. I want the script to do following:1. Import an excel document2. Create and rename new columns3. Assign formulas to the columns I start by clearing the log file and then proceed with steps 1-3, but somehow only step 3 is recorded and can be saved as a script. I am greatful for any suggestions about how to move forward (preferably an i...
carolinesanden

Discussions |
Jul 7, 2021 5:30 AM

580 views | 1 replies
Find string in column, rename the column and add new column in JSL

Hi All, I have a table like below and want to find the String "Z", "A" and "B" in the columns and rename it to "Z_A" and "Z_B".After that, I want to add a column after X_loc and Y_loc which converts them to mm. The formula that I want to use is (X_Loc / 1000).Can anyone guide me on how to do the scripting for this?Thanks
achid03

Discussions |
Jul 7, 2021 5:10 AM

1077 views | 1 replies
Regression with a multivariate linear mixed model - Am I doing this right? and how to I extract parameter estimates and their standard errors?

I have been working on a multivariate linear mixed regression analysis in JMP and would like to check in to determine: QUESTION 1. whether or not I am on the right track? Data collected for the analysis described below stems from a field experiment possessing a randomized complete block design, with 4 replications. The experiment has an additive design, in which crop density is elevated incrementa...
mmccollough18

Discussions |
Jul 7, 2021 2:09 AM

2432 views | 6 replies
How to make a calculus in JMP

How to make a calculus in JMP? There is a two dimension of data, for instance, current and time, then in JMP Grapher, we can plot a curve and fit it smooth, for detail, please see photo below.How much electric quantity will be? that means I'd like to know how to calculate the area under the curve?in mathmatic , how to make a calculus in JMP?
mujahida

Discussions |
Jul 6, 2021 3:25 PM

8176 views | 3 replies
Solving for new FPCs using a training set

Had a question on the Functional Data Explorer system. Feels like a dumb question but can't figure it out. So I set up a training set and developed FPCs I like. The next step is then to use that spline structure to solve the FPCs for new items as they come in. What steps would I take to do that?
Evan_Morris

Discussions |
Jul 6, 2021 11:08 AM

552 views | 0 replies

Previous
Next

Latest Discussions

Solving for new FPCs using a training set

Had a question on the Functional Data Explorer system. Feels like a dumb question but can't figure it out. So I set up a training set and developed FPCs I like. The next step is then to use that spline structure to solve the FPCs for new items as they come in. What steps would I take to do that?
Evan_Morris

Discussions |
Jul 6, 2021 11:08 AM

552 views | 0 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

687 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

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