Welcome to the JMP User Community!

Latest Discussions

• subset data table based on another data table

  Hi,   Lets say we have main data table and there is another data table we want to use to subset the main one + add some conditionals during this process;   main table Another data table     How can go through each row of Label column in main table to get the rows matched to subset tables rows (L1, L3, L5) and get rows when group == K and Number == 2   So the output table should look like    Ple...

  joshua

  Discussions |

  Sep 25, 2020 8:12 AM

  2777 views | 3 replies

• Fractional Factorial - Understanding Aliasing Matrix

      Hi all, I would like to design a fractional factorial design. There are 4 factors.I could afford only max 12 run, including 4 center points.The highlighted 8 runs with resolution 4 is chosen.  Now, come to the question. In terms of aliasing, the factor "GPN time" is known to have less significant impact. Therefore, the factor "GPN time" is afford to be aliased.  Above is the aliasing of effect...

  AmirSS

  Discussions |

  Sep 25, 2020 6:58 AM

  3134 views | 3 replies

• JMP multiple XY plots in a grid without headings

  Hello, I want to plot multiple XY graphs, representing steel defects over width (X) and length (Y).I want to arrange them in rows in a grid, by the coilnumber (product number).I use the following code:Names default to here( 1 ); Fit Group( Graph Builder( Size( 100, 300 ), Show Control Panel( 0 ), Show Legend( 0 ), Show Title ( 0 ), Variables( X( :PercentBr ), Y( :PercentLe ) ), Eleme...

  peter_caenen

  Discussions |

  Sep 25, 2020 6:22 AM

  3889 views | 6 replies

• How to Get Row Number When There is Missing Data

  There is missing value in my data.I'm trying to create script for new column 'Row Number' to get row number of lagged value of Col1(non-missing data).I'm facing problem when missing data is encountered.Below is my data with required row number outcome.How to create script for this? Row#Col1Row Number(outcome)111 218133424 35 36 372038 79 71024711141012171113 1214 12151612162515      

  bzanos

  Discussions |

  Sep 25, 2020 5:18 AM

  2117 views | 2 replies

• Color cells and points discretely

  I have a column with continuous data (millimeters) and I would like to color the cells according to spec and warn limits. The coloring should be discrete, not continuous. When creating a plot using Graph Builder, the points should be colored in the same way as the cells.This is the desired coloring:< -4: red>= -4 and <-2: yellow>=-2 and <=2: green>2 and <=5: yellow>5: red I tried using the column ...

  JWi

  Discussions |

  Sep 25, 2020 2:44 AM

  2750 views | 2 replies