Welcome to the JMP User Community!

Latest Discussions

• Get column Property and store as list

  I have a large data set and each column has spec limit  i am looping through the column names and trying to get spec Limit and storing them as a list. But somehow script is not storing the values of spec Limits in a list and giving only values for last iteration. any help on how to store spec values as list ?  data_cols = dt1 << Get Column Names (continuous);lsl= {};usl={};for (m =1,m<=NItems(data...

  RK1

  Discussions |

  Feb 8, 2018 9:26 AM

  6447 views | 2 replies

• How can I count the number of batches independently of samples?

  I have a series of batches produced over a period of years for which a different number of samples have been taken; e.g. see Table below. I want to be able to graphically visualise the number of batches per year but I cannot seem to be able to do that without having to build a new table in which I remove the repeats; i.e. the samples column. Is there an easy way to count and/or visualise the numbe...

  ChristopheG

  Discussions |

  Feb 8, 2018 8:21 AM

  9402 views | 3 replies

• find values and categorize

  Hello, I have the problem that I need to categorize some data. The selection of the values to be categorized would be much easier, if there was an automatized process. The problem is such: Table with 3 columns (1 category, 2 depths measurments, 3 number of data points). 1) I would like to get those that are below 0,5 (see example file column 2) for each lake respectively. This means, 0,5 should no...

  Pacco

  Discussions |

  Feb 8, 2018 7:22 AM

  18030 views | 9 replies

• Hive SQL Query builder - Performance issues

  Hi Guys,I'm running JMP 13 and have used the cloudera hive ODBC driver to sucesfully connect the JMP query builder to our hadoop hive server. I am able to view the tables ok, but once i click on one of the tables it automatically sends a "select * from table" query to the hadoop cluster which completely hangs up my JMP due to the enormous size of the table its trying to pull without my consent. Is...

  scott_87

  Discussions |

  Feb 7, 2018 10:11 PM

  4236 views | 2 replies

• remove elements in a list

  Hello, someone can help me.....i have two lists like this:   MYLIST = {:empty, :empty2, :Name("A:k"), :Name("A:m"), :Name("A:x"), :Name("A:y"), :NA, :Name("D:3"), :Name("D:6"), :Name("D:8")}; DELCOLS= {:empty, :empty2};     i would like remove the elements of list DELCOLS from MYLIST   expected results:   MYLIST = {:Name("A:k"), :Name("A:m"), :Name("A:x"), :Name("A:y"), :NA, :Name("D:3"), :Name("...

  gianpaolo

  Discussions |

  Feb 7, 2018 3:56 PM

  18136 views | 3 replies