JMP User Community

Latest Discussions

Overwrite data in a table

Hi, I am trying to clean up my data table. I have a table with some value which are "x", "X", "X-Direction", "X-direction", but they are all the same, which is "X". How can I change the values (in the script) so it overwrite everything with the same format ("X")? Because then, I want to split my data table and it gives me 4 columns where I should have only 1... Thanks!
LGaspard

Discussions |
Feb 3, 2023 7:01 AM

1512 views | 2 replies
Custom design - Help to split-plot/blocking

Hi JMP community, I am currently working on a custom DOE design. Overall I have 3 factors with varying levels. Stabilizer solution (I have 7 different stabilizer solution I would like to screen) + potentially adding a reference sample (no stabilizer added). Dosage of stabilizer - 2 levels (high and low) => (0,01% and 0,02%) Process (2 different heat treatments/autoclavations). The pilot plant ...
Bertelsen92

Discussions |
Feb 3, 2023 7:00 AM

7649 views | 9 replies
Dimension Reduction on large data sets

I am often dealing with data that has thousands of terms, and many thousands, sometime hundreds of thousands, observations. Many of the terms are usually correlated, so I would like to reduce the dimensionality. But if I try to use Principal Components to do this the computation time is excessive or downright impractical. Is there another method that would work better to reduce the dimensions o...
pcarroll1

Discussions |
Feb 3, 2023 6:59 AM

1123 views | 1 replies
how to optimize the cpu/memory usage in jmp on Windows

hi, I often have to handle data tables with few million rows and 20s to 30s columns. The frustration is whenever I need to edit a plot basing on this big table, the system start the waiting sign(turning ring) which take 1 to few minutes. It normally consume ~60% CPU and few GB memory if I look at the "task manager". Luckily I am using 64bit jmp on 64 bit Win7 workstation which has enough resources...
robust1972

Discussions |
Feb 3, 2023 6:27 AM

14423 views | 5 replies
How do I use a variable to reference a column in formula function?

Hi, I need to create a new column by apply formula on two existing column. I want to reference column through a variable rather than direct referencing. Here is the code , but formula seems doesn't recognize Column(ColVar). Anyone could help me to fix it? Thanks in advance. yCol = Column("weight"); xCol = Column("height"); Bivariate( Y( yCol ), X( xCol) ); colVar ="$weight"; dt = currentdatatable...
TraceTurtle5488

Discussions |
Feb 3, 2023 3:59 AM

1311 views | 2 replies

Previous
Next

Latest Discussions

Custom design - Help to split-plot/blocking

Hi JMP community, I am currently working on a custom DOE design. Overall I have 3 factors with varying levels. Stabilizer solution (I have 7 different stabilizer solution I would like to screen) + potentially adding a reference sample (no stabilizer added). Dosage of stabilizer - 2 levels (high and low) => (0,01% and 0,02%) Process (2 different heat treatments/autoclavations). The pilot plant ...
Bertelsen92

Discussions |
Feb 3, 2023 7:00 AM

7649 views | 9 replies
Dimension Reduction on large data sets

I am often dealing with data that has thousands of terms, and many thousands, sometime hundreds of thousands, observations. Many of the terms are usually correlated, so I would like to reduce the dimensionality. But if I try to use Principal Components to do this the computation time is excessive or downright impractical. Is there another method that would work better to reduce the dimensions o...
pcarroll1

Discussions |
Feb 3, 2023 6:59 AM

1123 views | 1 replies
How to make Dashboard of Dashboards without keeping datatables open in memory?

I have a 500 item dataset, each one made up of about 500,000 data points. I want to make a report from each sub dataset and present the overall results of the 500 items with all of the resolution. The trival way is to make a dashboard/app of multiple datatables, but even if hidden they still take up memory and this is not an option. The end dashboard should give insights to notice issues within su...
John89

Discussions |
Feb 3, 2023 2:28 AM

895 views | 1 replies
Design of Experiments based on covariates factors from two tables

Hi dear JMP enthusiasts and DoE lovers, I face a difficult situation and would like to know if there are any easier options. I would like to setup a DoE with 5 covariates : 2 covariates, from a table A, are predicted physico-chemical properties of formulations (thanks to the model of a first DoE),3 covariates, independent from the first ones, from a table B, are characteristics of different pack...
Victor_G

Discussions |
Feb 2, 2023 9:18 AM

1894 views | 4 replies
JMP 13 fails to open Excel files

Hello, I am JMP beginner and i have recently found a problem with my JMP 13 and specifically with the "open" option because i can't import Excel files and convert them into JMP tables.Whenever i try to import an Excel file it shows me this error "There was an error opening the file".However i can still manage to import my Excel files in JMP by dragging them to the JMP window, this gives me howeve...
CoxLeftLeopard3

Discussions |
Feb 1, 2023 7:39 PM

2085 views | 3 replies

Previous
Next

Latest Discussions

JMP Script Window - Hovering over a variable do not show the value stored in the variable if passed between scripts

I have found that hovering over a variable is very useful feature in JMP Script Window/Editor when debugging the script. I have been working with very long script which I have divided to smaller pieces by using Include-feature. I am able to pass variable content correctly between the included scripts but it looks like hovering do not work on included script windows (showing empty variable content ...
JanneI

Discussions |
Jan 27, 2023 5:51 AM

801 views | 0 replies
Choice experiment: probability profiler baseline assumptions

Dear community, For the probability profiler as used to analyse data in choice experiment analysis, I am wondering how to optimally set the baseline scenario to compare probability profiler data. Following for instance von Wedel & Hagist (2022), utilize the probability profiler to compare the baseline of the combination of attributes with the lowest marginal utilities. While such an analysis is ...
Declan_JMP

Discussions |
Jan 23, 2023 3:54 AM

1616 views | 0 replies
Can we find some tutorials videos in YouTube?

Hello everyone, passing by to say hello and to share that I created a YouTube Channel with JMP 17 Video Tutorials in english, spanish and portuguese.As an enthusiast about Problem Solving, passionated about JMP and a JMP Partner, I hope you'll come with me, subscribe to the channel and enjoy all the videos that are there and yet to come.https://www.youtube.com/@planaconsultoria Best regards!
Matheus_Plana

Discussions |
Jan 15, 2023 10:27 AM

1656 views | 0 replies
Data puzzles via Hanukkah of Data is underway

If you're looking for some data wrangling puzzles, the Hanukkah of Data series of daily puzzles is underway at https://hanukkah.bluebird.sh/5783/. They're on day 2 of 8 now. As far as I can tell, you can do them whenever and there's no competitive part. I'm doing them in JMP, of course!
XanGregg

Discussions |
Dec 19, 2022 11:21 AM

825 views | 0 replies
Slope and Intercept Collector error "matrix must be non-singular in access or evaluation of 'Inv' , Inv/*###*/(x` * x)"

HI all,I have a question about an error I'm getting when using @stan_koprowski's slope and intercept add-in. I've posted my question on the add-in's thread but due to the much lower exposure compared to discussion posts, I thought that it might be a good idea to ask here as well. I made a mock data table with three groups and several observations in each group. When I run the add-in I am getting t...
Lavik17

Discussions |
Dec 19, 2022 10:20 AM

965 views | 0 replies