Welcome to the JMP User Community!

Latest Discussions

• Calling a JMP Add-in Menu Item from within the Add-In

  My apologies if this is a question with a trivial answer. I've written a JMP add-in which contains an assortment of scripts, all of which are referenced by menu items (for example) "Program A", "Program B", "Program C" etc. I want to be able to run the script referenced by menu item "Program B" via a command contained within the script called by menu item "Program A". Can that be done? Note that I...

  DMR

  Discussions |

  Jul 18, 2018 9:26 AM

  5804 views | 3 replies

• 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

  9800 views | 10 replies