Welcome to the JMP User Community!

Latest Discussions

• create new column with assigned value by another column value

  I have a column with date, and want to create a new column,  need assign with {A, B, C, D, E} by judging another column unique date.Judge by "rundate" cell value(refer to below pic), kindly help on how to generate a script:1. assign new column Cell[1] == "A", i++, if "rundate" Cell[i] = "rundate" Cell[i++], keep assign new column Cell[i++]=="A".2. if "rundate" Cell[i] < "rundate" Cell[i++], means ...

  qspringleaf

  Discussions |

  Apr 13, 2020 9:53 AM

  2386 views | 2 replies

• Control chart of continuous temperature data

  Hello, I have conducted a stress experiment in chickens. I've monitored the leg temperature over a period of 7 days. For example, I introduced a loud sound to see what happens with the leg temperature (we expect it to drop after stressor induction). I have extracted the temperature 2 minutes before stressor induction and 2 minutes after stressor induction. So I have a vector of 7001 datapoints, si...

  SW1993

  Discussions |

  Apr 13, 2020 7:15 AM

  2960 views | 3 replies

• highligting the markers of particular rows in Bivariate plot

  Hi Trying to highlighting the markers of particular rows in Bivariate plot.I manuall created the plot and saved the to script window and manually selected 'Theme' column as row legend. But the problem is I don't see those steps above in the script when I looked it! Here is what I meandt = Open( "$sample_data/Hollywood Movies.jmp" ); dt = currentdatatable(); // Don't know I need this here anyway ...

  joshua

  Discussions |

  Apr 13, 2020 12:44 AM

  2836 views | 3 replies

• About Tables "Transpose" function

  Dear SirsI have question about the function for “ Transpose”.I would like the same action as excel easily..Table1->Table2.But JMP Transpose not allow different data type transfer at same time…so I need to modify items one by one (Num.  Char.)Once I need modify over hundreds of them, it takes long time.Question1: How to transpose data without modify data type?Question2: How to change data type syn...

  StevenChan

  Discussions |

  Apr 12, 2020 11:09 PM

  4620 views | 4 replies

• Deleting multiple columns based on strings in their name

  Hi, I need to delete multiple columns based the strings they contain but sometimes I want to keep some others even if they don't contain those strings. So by following this post's solution Deleting multiple columns based on column name    dt = Open( "$sample_data/Hollywood Movies.jmp" ); col_names = dt << Get Column Names( String ); For( i = N Items( col_names ), i > 0, i--, If( Not( Conta...

  joshua

  Discussions |

  Apr 12, 2020 11:03 PM

  6715 views | 7 replies