JMP User Community

Latest Discussions

Group Columns by a list of values from another column?

I'm working to group several thousand columns together by name that matches with something from a list of values from an initial column example:Col1 values = {step1, step2, step3}Col2:5000 names :step1_blahblahblah, step2_blahblbahblah, etc I guess I'm not quite sure how to define the if(contain) statement uses the list of values from Col1. dt = current data table(); Summarize( dt, StepIDIndex= by...
aliegner1

Discussions |
Feb 18, 2022 2:39 PM

1102 views | 1 replies
Prediction Expression from DOE not matching

I have a prediction expression from my DOE that when popped into excel to make a calculator, the results are not consistent with what populates the imp table column when I create a "Predict Formula" column in my table. It is very close for the center values but off for the values towards the limits of the model. What am I missing??
JasonMLawhorn

Discussions |
Feb 18, 2022 11:29 AM

875 views | 1 replies
Looping ANOVA to determine most similar group

Hi all,

I'm looking to loop a procedure that would otherwise be tedious. Potentially, someone may have a better workflow and I'm all ears if you do. For my dataset, I have 5 ethnicities and I'm trying to figure out what ethnicity 2 and ethnicity 5 match best to so I can combine the ethnicities. What I want to do is run an ANOVA and Welche's Test between 2 and the rest of the ethnicities and see if...
MikeDereviankin

Discussions |
Feb 18, 2022 11:27 AM

1151 views | 3 replies
Scripting and very large files

I have a script that imports many files and concatenates them. This file can be >41 million rows and be in the 10's of Gigabits (I have 100's of GB free space and 128GB memory : Using JMP16.2) I then have scripts to select rows and columns and such. My question really is not about scripting per se, but why if I run each script in order versus having a script that includes all the scripts...
justvince

Discussions |
Feb 18, 2022 9:02 AM

2699 views | 5 replies
Randomly choose an element in a list and remove the chosen one for next round

Hi all,I have a list[1,2,3,4,5,6,7,8,9,10] that I want to randomly choose an element, and then remove that element from the list for the next random selection. I need to repeat the selections 4 times.Is there a easy way to remove the selected element in the list? Both Remove and Remove From need the ith index of the elements. Thank you for your help.
midori555

Discussions |
Feb 17, 2022 10:15 PM

2896 views | 3 replies

Previous
Next

Latest Discussions

Group Columns by a list of values from another column?

I'm working to group several thousand columns together by name that matches with something from a list of values from an initial column example:Col1 values = {step1, step2, step3}Col2:5000 names :step1_blahblahblah, step2_blahblbahblah, etc I guess I'm not quite sure how to define the if(contain) statement uses the list of values from Col1. dt = current data table(); Summarize( dt, StepIDIndex= by...
aliegner1

Discussions |
Feb 18, 2022 2:39 PM

1102 views | 1 replies
Prediction Expression from DOE not matching

I have a prediction expression from my DOE that when popped into excel to make a calculator, the results are not consistent with what populates the imp table column when I create a "Predict Formula" column in my table. It is very close for the center values but off for the values towards the limits of the model. What am I missing??
JasonMLawhorn

Discussions |
Feb 18, 2022 11:29 AM

875 views | 1 replies
Looping ANOVA to determine most similar group

Hi all,

I'm looking to loop a procedure that would otherwise be tedious. Potentially, someone may have a better workflow and I'm all ears if you do. For my dataset, I have 5 ethnicities and I'm trying to figure out what ethnicity 2 and ethnicity 5 match best to so I can combine the ethnicities. What I want to do is run an ANOVA and Welche's Test between 2 and the rest of the ethnicities and see if...
MikeDereviankin

Discussions |
Feb 18, 2022 11:27 AM

1151 views | 3 replies
Scripting and very large files

I have a script that imports many files and concatenates them. This file can be >41 million rows and be in the 10's of Gigabits (I have 100's of GB free space and 128GB memory : Using JMP16.2) I then have scripts to select rows and columns and such. My question really is not about scripting per se, but why if I run each script in order versus having a script that includes all the scripts...
justvince

Discussions |
Feb 18, 2022 9:02 AM

2699 views | 5 replies
Random vs Fixed Blocking Factor in DOE

Hello All,

I am trying to setup a custom DOE experiment where I am evaluation 4 continuous factors with 1 response. I have a limit of 30 runs and am interested in main effects (later I would like to do two-way interactions as well if possible). I set this run up but because these 30 runs have to be split over two imaging platforms I use a blocking of two with 15 runs per. I tried with a fixed block...
Ekarshalev

Discussions |
Feb 17, 2022 8:36 AM

4587 views | 3 replies

Previous
Next

Latest Discussions

No table linking after saving the project?

Hi,when I generate a summary table with the option "link to original data table" (selected by default), the two tables are linked:By selecting a row in the summary table the corresponding rows in the original table are selected.Cool.This also works for selections in Graphs and Dashboards.Very cool! Now my problem:After saving both tables to a project file, (precisely: after close & re-open the pro...
hogi

Discussions |
Feb 3, 2022 4:19 AM

598 views | 0 replies
Setting Guardbands on Test Limits Using EMP

Hello. I am trying to use the EMP tool to help set guardbands to my test limits based on my gauge R and R data from a final test machine.I used 10 devices and measured these devices 5 times each, across 5 different test sites on the machine.I need to know how much to guardband my Upper and Lower specs. I am having trouble understanding how to apply the data in the EMP report. I feel like this is a...
Jbritsch04

Discussions |
Feb 2, 2022 8:49 AM

769 views | 0 replies
How to introduce lower bounds for simulated data in Profiler platform

Hi JMP community, (JMP Pro 16.0.0) I'm hoping to find out if there is a way to include lower bounds to simulated data in the Profiler platform. I have several predictors going into a model, but few data points to fit. So, in order to generate simulated ("synthetic") data, I use the Prediction Profiler platform along with the multivariate correlation structure of the data to generate thousands ...
SDF1

Discussions |
Feb 1, 2022 11:09 AM

589 views | 0 replies
Query Builder filtering on date stored in Varchar(20)

Query Builder - date filter.SQL ServerJMP version 16.2In the database (SQL Server) I get the Date field called RETURNDATE in ‘varchar20’ – I would like to use the Calendar functionality in the filter to select my dates I tried to create a calculated column (Calc1) and specify CAST([RETURNDATE] as date), which he doesn’t like. Using SQL outside Query BuilderSELECT TOP (1000) [LABJOBNO] ,[DESPA...
HansD

Discussions |
Jan 25, 2022 6:12 AM

1391 views | 0 replies
M1 Macbook Pro JMP Capabilities

Hi all,
I'm thinking about upgrading from my windows set-up and running a M1 Macbook Pro as my primary set up. I wanted to open up the discussion and see if any other JMP users were using the newest Macbook Pro and if they have run into any hurdles yet? I do a lot of R/Python integration. I do have a decent set up right now, but want to know if anyone else has tested out this connection and knows ...
MikeDereviankin

Discussions |
Jan 21, 2022 1:52 PM

789 views | 0 replies