Welcome to the JMP User Community!

Latest Discussions

• Extract numbers from string

  Hi, I want to extract all the numbers contain in [] and store in the list. Is there a way to achieve this with jsl? I would like to extract numbers from the column and store in the list which should look something like this: bins = {"52","79","39 41 43", "38 40 42", "1"};Any advice would be much helpful.Thanks

  Jackie_

  Discussions |

  Dec 9, 2022 9:11 AM

  2591 views | 4 replies

• How to import already created validation column in JMP?

  I have a dataset in which training and validation data points are already defined. First N rows are training data and remaining are validation data. Data set in Excel file.Now, how to use already created validation column (in Excel) while performing some analysis in JMP (e.g. neural nets).

  abhinavsharma91

  Discussions |

  Dec 9, 2022 7:39 AM

  853 views | 1 replies

• Evaluation column name from the list

  Hi, I've a list which contains numeric row values. I want to generate Variability plot based on the row values in list. I tried using Eval but something doesn't seem to work. Can someone assist?Here's my codeNames Default To Here( 1 ); Clear Globals(); dt = Data Table( "Untitled 910" ); dt2 = Data Table( "Soft Bin Summary" ); dad = dt2<< get column names(strings); r = dt << Get Rows Where( :Yi...

  Jackie_

  Discussions |

  Dec 8, 2022 6:35 PM

  1628 views | 4 replies

• Add Contents of script file as New Script to data table

  I have a saved jmp script.  Let's call it my_graph.jsl.  I want to take that script and add it to my current data table as a New Script().  I know thatdt << New Script(scriptname, code)will add a new script to the data table.  But it's not clear to me how to get the contents of my_graph.jsl and dump it in there.  I've tried playing around with Load Text File() but then I'm not sure what to do with...

  klk

  Discussions |

  Dec 8, 2022 9:32 AM

  3437 views | 4 replies

• Query Builder List Box offset values when space present

  I have a table in a database that contains a long list of names, some of which have the same name with a leading space. When using Query builder and using a List Box filter on this column, the names with and without the leading space only show up once in the list box filter, and it causes everything after that entry in the filter to be offset. I created a test database table with column Name and v...

  bculver

  Discussions |

  Dec 8, 2022 8:41 AM

  1524 views | 1 replies