Welcome to the JMP User Community!

Latest Discussions

• Extracting numbers from a set of numbers in a column

  Let say you have the following data table with 6 digits numbers in one column (Number 1) and you are interested in extracting only 4 numbers from those 6 numbers into a new column (Derived Numbers). How do you go about doing that? Thanks in advance.Number 1Derived Numbers201409201589201378201411201091

  jenkins_macedo

  Discussions |

  Jul 30, 2015 6:57 AM

  4430 views | 2 replies

• JMP 11 Pro: Distribution Platform - Normal Mixtures. How does JMP decide how to label the distributions?

  JMP 11 Pro: Distribution Platform - Normal Mixtures. How does JMP decide how to label the distributions?I fit a mixture of 3 normal distributions to a (single) response. The 3 distributions identified by JMP are labelled 1, 2 and 3 in the JMP output, i.e. (π₁, μ_1, σ₁), (π₂, μ_2, σ₂) and (π₃, μ_3, σ₃). How does JMP decide which of the 3 identified distributions to label respectively 1, 2 and 3? Is it...

  camth

  Discussions |

  Jul 30, 2015 6:48 AM

  5183 views | 4 replies

• JSL get values from a table and make into a text string that can be used as an input in another datebase query

  In my script I have multiple data base queries.   From one query it get a column with a list of lot numbers.  I want to take the values from this column and make them into a local variable that I can use in the next data query to pull data from a different database. using a script line below I get the value string.cassette = SLC:DESTINATION_CASS << get values; result cassette = {"SPQ093146 1"}How ...

  chris_dennis

  Discussions |

  Jul 29, 2015 3:55 PM

  14908 views | 2 replies

• Set Column Values

  I am creating several data tables, where I will add a Character column with repeating values.  I am using the repeat function to do this.  My trouble is that it seems to take a very long time for large repeat values.  Is there a more efficient way to do this?  I am using JMP11.  Thanks!// Example.Names Default To Here( 1 );t1 = Tick Seconds();dt = New Table( "50000 Rows", Add Rows( 50000 ),      N...

  robot

  Discussions |

  Jul 29, 2015 10:18 AM

  15431 views | 2 replies

• formula for "text to columns"

  Hi,I have a column with comma seperated values and by using column utilities text to column I get the column for each comma seperated value, however the dataset is growing hourl and by joining/concatenating the new data with the existing one I have to redo all the process again and again. Isn't there a formula for this (or better script)?Many thanks in advance

  saitcopuroglu

  Discussions |

  Jul 29, 2015 7:32 AM

  11263 views | 4 replies