Welcome to the JMP User Community!

Latest Discussions

• Increment a counter from 1 to n for every unique set of identical rows

  Hi everyone,   I figure what I want to do is really easy, I just haven't come up with a good way to do it. I have a large table with a substantial number of identical rows which I want to rename uniquely but in a reproducible way. Currently, I have a script that takes the following column:   A number 1 B number 1 A number 2 A number 3 A number 3 A number 3 B number 3 B number 3 B number 3 ...   In...

  screech

  Discussions |

  Nov 7, 2019 11:58 AM

  3192 views | 1 replies

• 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

  3076 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

  3098 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

  4974 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

  2673 views | 2 replies