Welcome to the JMP User Community!

Latest Discussions

• If-else in jmp (and ifmz)

  I know (now..) that if you have a possibility of having missing value and you would like to have it evaluated as 0 you should use IfMZ in JMP. What I'm wondering what is happening in the example below, if you have if-statement with "two elses" (won't return syntax error). In the example below it is expression if_expr_three (and same for ifmz_expr_three   Names Default To Here(1); if_expr_two = Ex...

  jthi

  Discussions |

  Feb 22, 2022 12:26 PM

  1715 views | 1 replies

• Joining two tables based on dates

  Hi,I want to accomplish something which I think is very simple: Joining tables based on dates.Let's say I have the following tables:Table1 - which has the following columns: Group1, event_date.Table2 - which has the following columns: Group2, start_date, end_date.I want the join to work as follows: (Group1 == Group2) AND (start_date < date < end_date)How can I accomplish this using a JSL code?Than...

  Yotam

  Discussions |

  Feb 22, 2022 12:05 PM

  3008 views | 3 replies

• Filtering and row selections

  I have data where each row is data from a certain day of a cell culture batch. Only the rows for the last day of each cell culture has the information for product quality. Now I am trying to filter out batches based on product quality at the end of the culture but I want to select all the days of those cultures so that I can compare them throughout the culture time. In the example the filter gets ...

  lara90

  Discussions |

  Feb 22, 2022 7:38 AM

  1309 views | 2 replies

• Problem with copying graph to word

  Hi.I am having an odd problem that I have not encountered before when I try to copy a graph from the graph builder to MS Word. Basically a big part of the picture crops off, and I am left with an unfulfilling graph. See pictures below. I used the selection (S) to choose which part of the graph to copy.Has anyone encountered this? It has never happened to me before. First picture is what I select, ...

  Vvvv

  Discussions |

  Feb 22, 2022 1:14 AM

  1002 views | 1 replies

• N Col using textbox value

  Hi all,I am trying to create a user input box that will determine the N Col for my line up box. I tried this script User_Input = New Window( "N Col", << modal(), hlistbox( Text Box( "Enter Column No: " ), Col_Num_teb = Text Edit Box( "", <<set width( 200 ) ), ), Button Box( "OK", col_num = col_num_teb << get(); ), ); lb = LineUpBox( N Col(col_num) );I tried entering 4 but ends up havi...

  UserID16644

  Discussions |

  Feb 21, 2022 10:22 PM

  1131 views | 2 replies