Welcome to the JMP User Community!

Latest Discussions

• Creating a column with yes/no value based on 6 other columns with yes/no values

  Hi all, I'm using JMP 11.2.1. Without using script, is there a way I can, in a data table, create a new column with yes/no values based on the yes/no values of 6 other columns? Basically, I would like to have a record in the new column have a "yes" value if ANY of the values of that record in the 6 other columns are a "yes" and a "no" value if NONE of the values of that record in the 6 other colum...

  rj69

  Discussions |

  Jun 7, 2017 8:43 AM

  11375 views | 5 replies

• how to analyse automaticly？

  dear all： i have to monito abnomal ratio every day， but now everyday i open the JMP and then put excel data in JMP to analyse， that is trouble。 if i open jmp and then analyse automaticly how i write JSL to realize？

  TONYMA

  Discussions |

  Jun 7, 2017 8:40 AM

  4797 views | 3 replies

• table summary in jsl

  what is the code for table summary ? I found the following code:Summarize(a = by( ENTITY ),maxHt = Max( ATTRIBUTE_VALUE ));new window( "SH Counter",Table Box(String Col Box( "ENTITY", a ),Number Col Box( "SH Counter", maxHt ),));
  1. can I get the the new summary in data table and not in "new window" ?2. if I need to have more "by groups" filter how do I add it to the code ?

  yaviav

  Discussions |

  Jun 6, 2017 12:49 PM

  21514 views | 5 replies

• Column Formula, Relative Value Calculations

  I have been trying to script a new column formula for a data table, where the calculated value changes based on values of columns to the left.  Example of what I mean using the "Big Class" example file. Let's say there are 200 rows as opposed to 20, each name appearing 10 times in succession as though the heights and wieghts were recoreded once a year for ten years, additionally there would be ano...

  FaxMachine

  Discussions |

  Jun 6, 2017 11:59 AM

  9200 views | 7 replies

• Status of Query running in the Foreground

  Is it possible to update the user on the status of a query running in the foreground using JSL? I have a SQL query that takes hours to run and the script needs to operate on the table after it opens so I cannot run it as a background query.  Currently I am using Open Database():/* fictitious database and table */ dt = Open Database( "DSN=ODBC Connection", "SELECT * FROM some_table" ) 

  ih

  Discussions |

  Jun 6, 2017 5:45 AM

  11840 views | 5 replies