Welcome to the JMP User Community!

Latest Discussions

• Splitting a data table by column id

  Hello, I have a large data table that the columns have an ID number followed by words like below, 1-Date1-parameter1-something2-something2-Date2-parameter3-parameter3-Date3-something3-else                     My ultimate goal is to automate control charts with Date as the sample label. There are not uniform amounts of columns for each ID and they are not sorted by ascending date.  My idea is to sp...

  CharlesIII

  Discussions |

  Jul 17, 2018 3:54 PM

  3986 views | 3 replies

• Adding up all the columns with names stored in a list

  I have create a list of column containing roughly the same name below: Xlist = {};
  Ylist = {};for(i = 1, i < ncols(dt2), i++,
  if(
  contains(dt2:i<< get name, "XXX") > 0, insert into(Xlist, dt2:i<< get name),
  contains(dt2:i<< get name, "YYY") > 0, insert into(Ylist, dt2:i<< get name),
  )
  ); I would like to create a new column which will give me a sum of the Xcolumn and Ycolumn. It is not working well for m...

  nguyendv06

  Discussions |

  Jul 17, 2018 12:46 PM

  9390 views | 2 replies

• how to get a sum of all columns with names stored in a list

  I have create a list of column containing roughly the same name below:  Xlist = {}; Ylist = {}; for(i = 1, i < ncols(dt2), i++, if( contains(dt2:i<< get name, "XXX") > 0, insert into(Xlist, dt2:i<< get name), contains(dt2:i<< get name, "YYY") > 0, insert into(Ylist, dt2:i<< get name), ) );  I would like to create a new column as below which will give me a sum of the Xcolumn and Ycolumn. It is not ...

  nguyendv06

  Discussions |

  Jul 17, 2018 12:45 PM

  8033 views | 1 replies

• Delete Duplicate Data from Table using Time Stamp

  I apologize, i know this question has been asked quite a few times on this forum but I haven't been able to find a solution to my problem.I have a large data set  ~24,000 rows of test data. Our process is to run a 5 step validation on 5 die and once we get the results we begin testing which ultimately means i am going to have repeat data on those 5 sites.  This 5 step validation verifies the conta...

  Yngeinstn

  Discussions |

  Jul 16, 2018 12:03 PM

  9799 views | 10 replies

• JSL Check Box Set Size

  Hello JMP folk, Is it possible to change the size of a Check Box by script? Looking through the documentation I set the max size before changing the Height & Width but I have still not been able to increase the checkbox size. Have not found any other topics on this in the forum.  windowMain = New Window( "test", //Header Outline Box( "", H List Box( Check Box( "", << Set Max Size(30,30),...

  RBILLC

  Discussions |

  Jul 16, 2018 11:45 AM

  11616 views | 6 replies