Welcome to the JMP User Community!

Latest Discussions

• Error: Cannot set value for the column '' because the row number (-1) is not valid

  I have a data table with 2 rows from an import from Excel and am trying to extract some data. Reticle1name = :Reticle[1];//Reticle is a column Reticle2name = :Reticle[2]; Reticle1X= :Closest DUT# X[1];//Closest DUT# X is a column Reticle2X= :Closest DUT# X[2]; Reticle1Y= :Closest DUT# Y[1];//Closest DUT# Y is a column Reticle2Y= :Closest DUT# Y[2]; AlignmentBump= :Alignment Bump[1];//Alignment Bum...

  Hegedus

  Discussions |

  Apr 3, 2015 6:06 PM

  14245 views | 1 replies

• Control Chart & 3 Sigma

  With reference to the table attached: I have about 30 observations. The values have a std deviation of 0.534121. The average is: 73.93235. Now if I want to calculate the control limits based on the thumb rule of ± 3 sigma, the limits come out to: 72.3 LCL and 75.5 UCL.However if I plot a control chart with the table in the attachment, the UCL and LCL are calculated to be:  72.852 to 75.01. I am un...

  none1

  Discussions |

  Apr 3, 2015 11:52 AM

  48647 views | 14 replies

• Is there a way to extract columns used in a formula?

  Hello folks-I'm trying to create a new button in my platform which would extract selected columns from a step-wise analysis and then build up univariate distributions of each selection. The limitation is that the extraction of columns selected and building the distribution is held to the specific column names in the list. I would like to be able to dive into the column to check if it is a formula,...

  andrew_j_parker

  Discussions |

  Apr 3, 2015 8:19 AM

  17550 views | 5 replies

• text to columns but in a neat way

  Hello all,I have a column of character data set which consist of codes of discounts we give our agencies. Also there are rows with empty data (no discount)I would like to get a result as below without generating any additional row:

  saitcopuroglu

  Discussions |

  Apr 3, 2015 7:17 AM

  13193 views | 6 replies

• confused over JSL in expression form

  I want to store a small table in another table so that a script that uses both in the same report can reconstruct the small one whenever it's called for.  This seems a nice solution because then users of the table can also easily open that small, related table of info while only storing one datatable.I did get the following to work, after much gnashing of teeth over layers of expr() syntax....dt =...

  hardner

  Discussions |

  Apr 2, 2015 9:21 AM

  14153 views | 3 replies