Welcome to the JMP User Community!

Latest Discussions

• select where statement for column value comparision

  Got back to JSL after a long break and feeling rusty.Can't get a select where statement work.I'm sure it's pretty simple.I'm trying to select rows by comparing a value with values in two other columns. dt << select where( :Col1 > :Col2 & :Col1< :Col3);Col1 is character(on purpose) because it needs to be used further and Col2,Col3 are numeric cols.What is wrong?I even tried doing this from GUI but ...

  ENTHU

  Discussions |

  Nov 7, 2019 11:18 AM

  2827 views | 3 replies

• Issue with word and substring

  I am working on a data table with more than 4000 rows.To get the data in required format I'm using word and substr functions within for each row loop. The functions work as expected for first 160 rows and no action is taken on rows beyond this point.Is this a network issue ? I tried adding Wait but doesnt help. For Each Row(dt:col1 = Word(1,dt:col1, "S")); For Each Row(dt:col2 = Substr( Char(dt:c...

  ENTHU

  Discussions |

  Nov 7, 2019 10:18 AM

  2795 views | 3 replies

• Functional Data: missing values imputation?

  Hello, I have a collection of X,Y curves I would like to analyize with Functional Data Explorer.  The problem I'm facing is that some of these curves are truncated at a certain value of X  because for greater values  a physical failure occurs during data collection. Some other curves reach the maximum possible X with no failure.  FDE is appearently not managing very well the presence of curves wit...

  matteo_patelmo

  Discussions |

  Nov 7, 2019 4:55 AM

  4580 views | 5 replies

• Cumulated sum of rows in new column by different columns

  dt = Current Data Table(); // List of column names for the table col_names = dt << get column names( string ); // Create cumulative sum of each D looking_for_channel_1 = "D"; For( i = 1, i <= N Items( col_names ), i++, // search column names for "D" If( Starts With( col_names[i], looking_for_channel_1 ), new_col = dt << New Column( Char( col_names[i] ) || ">=", Numeric, ....................

  Martin91

  Discussions |

  Nov 7, 2019 3:48 AM

  2453 views | 2 replies

• Overlay Plot Scripts Running as Graph Builder in JMP 15

  Folks, I've written dozens of JSL scripts that display my data using the Overlay Plot platform. With JMP 15, all these scripts are now run using the Graph Builder platform. This is creating a whole host of issues since the complex commands I've used in my OPs don't match up with, nor are they converted to, the appropriate GB commands.  Is it possible to turn off this "feature" and allow my scripts...

  terapin

  Discussions |

  Nov 6, 2019 1:27 PM

  4157 views | 3 replies