Welcome to the JMP User Community!

Latest Discussions

• Supprimer l'heure de l'affichage Calendar Box

  Bonjour, J'ai un code JSL qui demande à l'utilisateur de spécifier un intervalle de temps via une Calendar Box. Mon code fonctionne bien je souhaite seulement pouvoir supprimer l'affichage de l'heure qui ne m'est pas utile par la suite. Est ce que c'est possible ?         dt1=Today(), dt2=Today(), HListBox( PanelBox( "From Time", scal = Calendar Box(SetFunction(Function({this}, date1=scal<< Get ...

  Elise_B

  Discussions |

  Jul 5, 2021 7:08 AM

  1582 views | 3 replies

• Concatenate selected row from multiple subsetted data tables into 1 new data table

  Hi,

I have a data set(as example, Big Class) that contains all the data. I subset the data by age and select first row of each
subsetted data table. Then, I subset it again so that I can do concatenation of the selected row data into new table.

I notice that there is additional data (unwanted data ) concatenated in the new table (highlighted in red rectangular).
I am not sure what is the problem o...

  bzanos

  Discussions |

  Jul 5, 2021 5:06 AM

  1773 views | 2 replies

• Fixed line style based on name in Graph Builder

  Dear, I would like to know if and how it is possible to always have a fixed line style/color based on a certain criteria (e.g. in the case below based on the Quarter).If you take the sample data file "Australian Tourism" and plot the Room occupancy (%) versus Year you would get something like below,where I changed the line style for Quarter 2 to be dashed.However when I select only Quarters 2,3 an...

  PietVanmeerbeek

  Discussions |

  Jul 5, 2021 2:40 AM

  1762 views | 3 replies

• Error on Filter Condition on SQL Query

  Hi,I am trying to get data from a Access DB via SQL Query.I configured a filter on the column StudyID. The user should insert the value in a window text box before the query execution and such value is stored in the study_id_selected variable.It seems that the syntax of the SQL Query filter is not correct because I get the following error:Below you can find the whole script. Could you tell me whic...

  FabioSaragoni

  Discussions |

  Jul 5, 2021 1:37 AM

  1409 views | 1 replies

• JSL select rows with certain string and make subset

  Hi All,   I want to select certain rows that have string ended with "452" in column "Sample_ID" and make a subset containing these rows. I try to do like below but it didn't work   Names Default To Here( 1 ); Clear Log(); Clear Symbols(); Close All( Data Tables, NoSave ); Close All( Journals, NoSave ); // pick data table 1 dt1_dir = Pick Directory( "Select directory for data table 1" ); dt1_Name ...

  achid03

  Discussions |

  Jul 5, 2021 12:42 AM

  3650 views | 5 replies