Welcome to the JMP User Community!

Latest Discussions

• Pick File: Syntax of filterList argument

  I am having trouble using the pick file command, in particular the filterList argument, and unfortunately, the scripting index does not cover my case.I want to set the filter to only csv (or Text files) during selection, as I can when using Open, and triedNames Default To Here( 1 ); mypath = Pick File( "Select csv File", {"Text Files|txt;csv"} );but when executing the script, the filter is set ...

  Feli

  Discussions |

  Oct 22, 2020 5:36 AM

  1729 views | 2 replies

• Question about "word" formula, purpose to split one character and get key shorten word

  I have one table with one column, name is "Batch ID", I want to use one script to generate one column, name is "Short ID", formula use Word( 2, :Batch ID, "L22DD1" ), only want to get 2nd word, for example, E3L22DD1K27--->K27, but how come after run JSL, its outcome is K2 not K27? kindly help to sugget whether have other solutions if it not work? Batch IDShort IDM3L22DD1K2K2E3L22DD1K45K45M3L22DD1K...

  qspringleaf

  Discussions |

  Oct 22, 2020 2:16 AM

  2990 views | 5 replies

• Script to Save Residuals of Spline Fit

  Hello, Anyone knows how to write a script to sava residuals (or predicteds) as a new colum for spline fit? It is easy if i do it manually, just need to select Save Residuals in the dropdown red triangle. I know how to write scripts to save residuals as a new column for liner fit using Fit Model. However, I often need to fit time-trend data using standardized x spline fit, and i am not sure if ther...

  Peng

  Discussions |

  Oct 21, 2020 2:13 PM

  10677 views | 9 replies

• Count Sum of Repeat Occurrences By Specified Variable?

  I would like to create a count sum formula which sums the number of occurrences of a value by a specified column variable.I want to know by a specified column variable value (i.e. Month) how many times did the same value appear in the column of interest.Example:  Sum Type of Fruit By MonthNew Column ( "Count_Fruit_Mo",                        numeric,                         continuous,            ...

  aandw

  Discussions |

  Oct 21, 2020 11:48 AM

  15100 views | 6 replies

• How to close database connection after running a New Sql Query?

  Steps to reproduce: Run any new sql query: query << Run Foreground( OnRunComplete( Write( "Number of rows in query result: ", N Rows( queryResult ) ) ) ); MyRunCompleteFunc = Function( {dt}, {Default Local}, Write( "Number of rows in query result: ", N Rows( dt ) ) ); query << Run Foreground( OnRunComplete( MyRunCompleteFunc ) );Next, if you try to delete the database, it will say that jmp ...

  douglaschong

  Discussions |

  Oct 21, 2020 11:30 AM

  2094 views | 1 replies