Welcome to the JMP User Community!

Latest Discussions

• 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

  21503 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

  9175 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

  11818 views | 5 replies

• get rows where and select where

  I'm seeing a weird issue with get rows where when trying to make it dynamic.dt = Open("$SAMPLE_DATA\Big Class.jmp");dt << get rows Where(:Sex == "F"); //Worksdt << Get Rows Where(Column("Sex") == "F"); // Doesn't Work//but ... col = :Sex; //doesn't workcol = Column("Sex"); //Works//so trying to do dt << Get Rows Where (col == "F");//can't work in any way that I can see
  Tried a few different version...

  vince_faller

  Discussions |

  Jun 5, 2017 9:02 PM

  16765 views | 5 replies

• Create a RSM using already collected historical data

  Hi, I have a dump of historical values for the explanatory and response variables. How do i build an RSM given this data? Can i build a custom design based on data already collected for a series of runs?

  soumyar

  Discussions |

  Jun 5, 2017 10:07 AM

  8835 views | 6 replies