Welcome to the JMP User Community!

Latest Discussions

• How to extract only numeric values out of text string

  I have a large data table which has a  column containing char text.    An example of the text  description is  listed below.I need to do some descriptive statistics on the duration to open/close for the robot.  I would like to extract the numeric portion of the character string and put it in a new column with numeric data type.Is there a formula function I could use to do that  on a brand new colu...

  jayv_

  Discussions |

  Jul 30, 2018 8:37 PM

  20201 views | 11 replies

• Changing Legend Labels

  I'm creating a bar graph in graph builder and the default names on my legend are "Mean(Treated Seed)" and "Mean(Control Seed)". I would like to change them to just say "Treated Seed" and "Control Seed"  When I open up legend settings and rename the legend item, the preview indicates that the change has been accepted and displays exactly how I want it, but when I press the "OK" button, Nothing chan...

  Mananahi

  Discussions |

  Jul 30, 2018 4:58 PM

  5711 views | 3 replies

• use while loop to add rows

  Hi all,I want to continously add rows to an empty data table until a condition is met but I am not sure what to do.In the following example, the condition is whether all elements in the vector in "steady state" are ones.ret = New Table( title, New Column( "P", Numeric, "Continuous", Formula( ptable << get as matrix ) ), New Column( "X(n)", Expression, "None", Formula( If( Row() == 1, init_...

  vistacc

  Discussions |

  Jul 30, 2018 9:26 AM

  6446 views | 3 replies

• how to remove "Where" from graph builder report window

  Hello,I have a script, that creates multiple graphs by parameter and put them in a report window.the output creates a text above the outline box "Where parameter=param", i would like to remove that. how can i do that? this is the snippet of relevant code: graph = panel Box(); Build_chart = Function( {param}, gb = dt1 << Graph Builder( Size( 1024, 725 ), Show Control Panel( 0 ), Auto Stretc...

  samshaw

  Discussions |

  Jul 29, 2018 1:05 PM

  3296 views | 3 replies

• SQL - Insert List from JSL to SQL Query

  Good Afternoon, I am running into problems trying to pass a list of selected wafer from JSL into an SQL query. Currently i am able to bring in a single lot and do the data analysis with no problems. However, because i am only able to bring in one single lot i have to basically re-run the script when i want to look at wafers. Translating from JSL to SQL has me stumped and even more sometimes i get ...

  Yngeinstn

  Discussions |

  Jul 29, 2018 8:40 AM

  2579 views | 1 replies