Welcome to the JMP User Community!

Latest Discussions

• 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

  1770 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

  1760 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

  1403 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

  3646 views | 5 replies

• Classer les valeurs uniques d'une colonne selon un calcul de pourcentage

  Bonjour,J'ai une table de donnée de très grande taille (environ 6 million de lignes). Elle a notamment comme colonnes une colonne Date, une colonne Référence Produit et une colonne Résultat (qui a deux valeurs possibles : OK soit NOK). Chaque ligne correspond à un test de composant.Je voudrais pouvoir laisser l'utilisateur sélectionner une période ou une date. A partir de cette période je voudrais...

  Elise_B

  Discussions |

  Jul 5, 2021 12:20 AM

  1470 views | 2 replies