JMP User Community

Latest Discussions

How do I associate three different columns together using namespace?

I have three columns of data that I want to associate each row with each other. I was looking at namespace since I have to return a list back to another file. (Assuming I can use one singular list of lists within it to select the rows of data). If this is not the best way to do it (as a result of being too messy or better ways to do it). How can this be achieved? Below is what I have so far, the c...
Andyon98

Discussions |
Jul 1, 2022 9:22 AM

1333 views | 5 replies
Easy way of reordering columns

I have a script that reformats many files and performs some analysis producing a final summary table, however the order in which the calculations are done and new columns are added doesn't produce a very readable format.I would like to pass the list of column names in the order I want them.Is there a built - in way of doing this? e.g. if I had a table with: Column 1, Column 2, Column 3, Column 4 I...
Agustin

Discussions |
Jul 1, 2022 8:59 AM

1132 views | 3 replies
How to get axis labels to the left of x-axis

I made a scatter plot with three variables on the x axis as shown below, but the label for the the axes (xC/ xB / xA) are at the bottom which can be unintuitive. I was looking a way to get the labels for the x axis to the left of each x-axis i.e xA on the left of "A1 A2 A1 A2...", xB on the left of "B1 B2...." and so on, so that it forms sort of a hierarchical table. (I am new to jump, so not sur...
cslim

Discussions |
Jun 30, 2022 11:23 PM

1458 views | 3 replies
Generate extra columns and its values based on two tables.

Hi All,

I need some help in doing a calculation based on two separate data sets. First data set has different values in different columns. And in 2nd table, there are three main character columns. Now based on a these three columns and based on matching other conditions, we need to perform subtraction operation in first table and results need to be store in a new column in first table.
Something lik...
HSS

Discussions |
Jun 30, 2022 5:13 PM

790 views | 1 replies
Definitive Screening Design DOE for a large number of factors

Dear JMP experts,I'm doing a dual-lens design DOE to couple lights into a fibre array. My goal is to look at the yield of the system when taking into account both the manufacturing tolerances and decenter and tilt of both lenses. I have 15 factors and 4 responses in the DOE. The 4 responses CE1, CE2, CE3 and CE4 correspond to the coupling efficiency of each fibre in the fibre array. I tried to use...
hanyu119

Discussions |
Jun 30, 2022 1:53 PM

3013 views | 14 replies

Previous
Next

Latest Discussions

How to get axis labels to the left of x-axis

I made a scatter plot with three variables on the x axis as shown below, but the label for the the axes (xC/ xB / xA) are at the bottom which can be unintuitive. I was looking a way to get the labels for the x axis to the left of each x-axis i.e xA on the left of "A1 A2 A1 A2...", xB on the left of "B1 B2...." and so on, so that it forms sort of a hierarchical table. (I am new to jump, so not sur...
cslim

Discussions |
Jun 30, 2022 11:23 PM

1458 views | 3 replies
Generate extra columns and its values based on two tables.

Hi All,

I need some help in doing a calculation based on two separate data sets. First data set has different values in different columns. And in 2nd table, there are three main character columns. Now based on a these three columns and based on matching other conditions, we need to perform subtraction operation in first table and results need to be store in a new column in first table.
Something lik...
HSS

Discussions |
Jun 30, 2022 5:13 PM

790 views | 1 replies
Definitive Screening Design DOE for a large number of factors

Dear JMP experts,I'm doing a dual-lens design DOE to couple lights into a fibre array. My goal is to look at the yield of the system when taking into account both the manufacturing tolerances and decenter and tilt of both lenses. I have 15 factors and 4 responses in the DOE. The 4 responses CE1, CE2, CE3 and CE4 correspond to the coupling efficiency of each fibre in the fibre array. I tried to use...
hanyu119

Discussions |
Jun 30, 2022 1:53 PM

3013 views | 14 replies
script into sql

Hello All,I always need to turn a list into a format that can run as sql, like this:LISTABCDEinto in('A','B','C','D','E') Right now, I have to use 'query builder->filter the table->select from a list' then copy the [ in('A','B','C','D','E') ] from there. Is there a scripting way that I can use as template no matter what list I work on? Like I run the same code then get the list in sql way....
Isabel26

Discussions |
Jun 30, 2022 1:00 PM

1422 views | 5 replies
Need help with JSL script for multi segments partition selection

The following code helps to create new tables with good but only one selection can be chosen for bad population with the partition window open. I want the partition screen to be open but the user can select more than one leaf nodes for the bad population and rest will go to good population. Is there a way to do this?dt = Open("$SAMPLE_DATA\semiconductor capability.jmp"); filepath = "$Desktop"; nw...
shasha_2

Discussions |
Jun 30, 2022 12:57 PM

633 views | 1 replies

Previous
Next

Latest Discussions

Urgent: covariance parameter estimates are all zero (i.e. estimate, Std error, confidence interval)

Dear All,I have been analysing a two factorial (3*4) RCBD repeated measures design by using the mixed model approach in JMP. Above is a section of the report I got. Why are the estimates zero. Other information include about the analysis include:1. 14 continuous variables measured four times at unequal time periods2. All the three covariance structures I tried (AR1, Toeplizt and spatial power) had...
MomentMonster90

Discussions |
Jun 13, 2022 5:53 AM

618 views | 0 replies
Validate column values (make sure all values in column follow a specific pattern)

Is there a better way rather than iteration of all the rows to validate values in column? Let's say before making something with the column I want to make sure that all values in column match specific Regex. Like so:!IsMissing(Regex(Column(myColumn)[1], "^\w+(\d{3})\w+$", "\1"))I can iterate through each row to make sure that all of them match, but maybe there is a better way?
miguello

Discussions |
May 6, 2022 11:09 AM

484 views | 0 replies
SUR (Seemingly Unrelated Regressions)

HI, How to find estimators of FGNLS and NLS (Seemingly Unrelated Regressions) Using JmpPro.# Note that it is present in SAS in the proc syslin
and it is in stat in the nlsur command Regards
Raaed

Discussions |
May 5, 2022 4:45 PM

625 views | 0 replies
Friedman post hoc analysis

Hello, I am trying to do a matched sample analysis across three different factors. I wanted to:1. Confirm that my sample would be what I pick for 'Block" when I do Fit Y by X when running Friedman's test2. Is there a post hoc analysis in JMP that I can use? I dont see Nemenyi or Conover as an optionThanks for your time.
pnakashe

Discussions |
May 5, 2022 12:02 PM

781 views | 0 replies
JMP script: Script Alarm Control chart- Table with atypical batch number and values

Hello everyone,I am trying to make a table with the OOT (out of Trend) batches with their respective "atypical" values.I used for that the "script alarm" function as I could found some exemples on the JMP community. Here is my script: z_KSigmaZ =1.4; // Création de la Carte de controle si N catégories > 5 Names Default To Here( 1 ); If(N Items(Associative Array(:"RNS/NS tordu (srg)")) > 5, Gr...
Sebastienlg

Discussions |
Apr 29, 2022 6:29 AM

554 views | 0 replies