Welcome to the JMP User Community!

Latest Discussions

• JSL Turning on Spec Limits "Show as Graph Reference Lines"

  I have a great script I borrowed from somewhere to import multiple spec limits and assign them to the each column. Is there a way when editing a column's specification to also check the box unders Spec Limits for "Show as Graph Reference Lines"? Right now I have to do this manually.  dt = Current Data Table(); dt2 = Open(); Current Data Table( dt ); nw = New Window( "Select Process Variables", Te...

  clausa

  Discussions |

  Jun 7, 2019 7:40 PM

  2101 views | 1 replies

• Shelf life prediction

  Hey everyone, There is any way to estimate the shelf life of a pharmaceutical product based on historical data of other batches by giving only one result? The goal is to predict, based on the primary result, if a product will survive until its expiry date. Thanks in advance. 

  LimVitamed

  Discussions |

  Jun 7, 2019 12:16 PM

  6469 views | 5 replies

• How to write multiple 'Contains' in SQL query

  Hello everybody.  Let's say I have an array with strings that are values of rows that I need to pull from DB. Let's say the array is:searchStringArray = {'qwe', 'rty', 'asd',' fgh', 'zxc'}I can construct my WHERE statement in my query in a pretty simple way:"WHERE t1.column1 IN (' " || Concat Items(searchStringsArray, " ', ' ")|| " ' )"which when parsed would give me the following string:"WHERE t...

  miguello

  Discussions |

  Jun 7, 2019 10:29 AM

  21724 views | 4 replies

• Change Values in a Column to UpperCase

   Question: I have a data table with data values in upper and lower case text strings in one column.I expect that the code will need to loop through each row, select the column of interest and set the value in the column to uppercase. I am having an issue figuring out the correct syntax to do this. This is what I have so far, but don't think I am close enough. Thanks to any help that can be provide...

  JensRiege

  Discussions |

  Jun 7, 2019 10:11 AM

  10886 views | 6 replies

• Questions on Survey Analysis

  Hi All, I am working on the survey data in JMP (Analyze --> Consumer Research --> Categorical) and i wanted to get your advise on the below 1. How to hide rows/columns in the survey output table ?
  2. Is it possible combine two variables ? If yes, how can i do it  ? 
  3. In the survey output table, if i have a supercategory in the 'Top' variable , it doesnt show up in the 'survey output table'. How ca...

  Ravi814

  Discussions |

  Jun 6, 2019 8:23 PM

  3523 views | 3 replies