Welcome to the JMP User Community!

Latest Discussions

• Median Absolute Deviation --> Export To Table for further tSNE

  Dear all,I am currently working on a project using 57 samples and >800 000 variables (see image attached). Now I would like to reduce the variables by using only the ones with highest median absolute deviation (MAD). The goal would be to process the data further with PC Analysis, followed by a t-SNE (I am using the nice JMP add-in).So far I am struggling with the identification of the variables wi...

  Pat1

  Discussions |

  Jun 8, 2019 2:06 PM

  8581 views | 4 replies

• 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

  21722 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