Welcome to the JMP User Community!

Latest Discussions

• Script to select columns from a list in clipboard

  Follow up....still problem.   I need to convert a list of strings copied from row values which, when pasted here looks like thisTcea1 Atp6v1h Oprk1 Rb1cc1 Fam150aWhen pasted in the script window it looks like this Tcea1Atp6v1hOprk1Rb1cc1 I need code to convert the clipboard contents to this {Tcea1, Atp6v1h, Oprk1, Rb1cc1, Fam150a} and this does not work ....  {"Tcea1, Atp6v1h, Oprk1, Rb1cc1, Fam15...

  EugeneB

  Discussions |

  Sep 27, 2021 2:10 PM

  3580 views | 7 replies

• Copying Row values to other Column

  Hello, Kindly help me I'm stuck when putting a formula into other column.Here is expected output if SerialNumber is not empty copy row to Column ChipID else copy the same SN.dtraw << New Column("ChipID", Character, Formula( For( i = 1, i <= N Rows(dtraw), i++, If( Is Missing( :SerialNumber), :ChipID[i] = (:SerialNumber[1] & i = 1), :SerialNumber ) ) ); 

  JeffO

  Discussions |

  Sep 27, 2021 1:56 AM

  1619 views | 2 replies

• break a single column into multiple based on empty row or specific character

  Hi,can someone provide advice?I have a column with structure below:
  123 abcdef xxyyzz
  
  is it possible to divide to multiple columns based on empty row (or a repeated same character) 1 a xx2 b yy3 c zz   d   e   f

  dadawasozo

  Discussions |

  Sep 25, 2021 8:08 AM

  1170 views | 2 replies

• How to efficiently find the first position in a specified range of data that meets the requirements?

  For example, Big Class.jmp
  The calculation steps are:if(row()>30,contains(:height[Index(1,30)],abs(:height[Index(1,30)]-:height)<3))
  If the number of lines is greater than 30,
  compare the data with the absolute value difference between the height of lines 1 -- 30 and the height of this line is less than or equal to 2, and calculate the number of lines 1 -- 30 that meet the above conditions first.Than...

  lwx228

  Discussions |

  Sep 24, 2021 6:43 AM

  2533 views | 4 replies

• Using SPC but with variable target/USL

  Hi, I am looking for some advice using SPC to monitor Actual Yield vs Planned Yield.  Plotting the SPC to measure Actual Yield (%) alone is straightforward, and normally when there's a single fixed value for an USL or a Target, this is also easy to add. However, for each month there's a Planned Yield value and this varies from month to month. The Target or USL seem to require a fixed value - so wh...

  jpollock

  Discussions |

  Sep 23, 2021 3:35 AM

  4224 views | 7 replies