Welcome to the JMP User Community!

Latest Discussions

• JSL how to rename column name by expression

  Hi, I have a list of of columns name that generated by Summary statistic. I want to remove all the prefix and sufix that only keep the part that i want. how do i do this in JSL?  Columns% of Total(UP9019-01) => UP9019-01% of Total(UP9019-02) => UP9019-02% of Total(UP9019-03) => UP9019-03.....

  OneNorthJMP

  Discussions |

  Oct 22, 2020 10:07 PM

  7945 views | 4 replies

• 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

  1954 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

  3291 views | 5 replies

• Creating Summary Table for Line of Fit?

  Hello, I have a script that generates Graphs using Graph Builder and Bivariate in a window. The function is shown below. Sorry if it is confusing, I had to hide the actual column and data table names. Essentially, the data table called upon in the function contains different lot numbers in rows, and different tests in columns.The function generates a graph for each test parameter vs time, and also...

  DanAlexander

  Discussions |

  Oct 19, 2020 1:06 PM

  4435 views | 4 replies

• how to script for finding maximum, minimum date value in a row for 100+ columns

  i have a table with 500+ rows and 100+ columns. Populated with numeric values (dates). I need to find the maximum and minimum value along each row for earliest and latest date. i guess the script would be similar to 'Maximum (column1........column100)' for each row. But i am not sure how to script the column ranges along each row.  

  tonkatsu2020

  Discussions |

  Oct 16, 2020 1:29 PM

  6553 views | 10 replies