Welcome to the JMP User Community!

Latest Discussions

• Replace value of specific row in Table B with value from specific column in Table A

  Hello Experts, I'm trying to automate updating my "GetLimitTable" with new data (I'm using Levey Jennings).How to replace value of specific row in Table B with value from specific column in Table A?For example, I want to;-  replace row _Std Dev Value from 18.769 (Table B) with 10.312 (Robust Standard Deviation Table A)-  replace row _Mean Value from 166.526 (Table B) with 166.1056 (Robust Mean Tab...

  WebDesignesCrow

  Discussions |

  Feb 24, 2023 12:28 AM

  1207 views | 2 replies

• How to read two rows from txt-file as column name

  Hello, Is there an option in JSL to read in the first two lines of a text file as a column header or
  alternatively (and even better) the first as Column name and the second as the column property (Units)Thank youMirko   @martindemel 

  mlo1

  Discussions |

  Feb 23, 2023 8:42 AM

  4428 views | 6 replies

• Looking to automate a process and coming at problem from two methods, looking for guidance:

  Hi all, I'm running a script that takes a column from a data table and summarises it like so:names default to here(1); dt = Current Data Table(); fails = dt << Summary(Group( :Test_Name ),Freq( "None" ),Weight( "None" ),Output Table( "Tests that have Failed" ));The general method in our process is to select a row in the table created:There can be any number of rows in this first summary table sho...

  OC200m

  Discussions |

  Feb 23, 2023 7:13 AM

  918 views | 1 replies

• Trying to Check if a number is in Binary format

  Hey all, I'm trying to write a script that takes an input and encrypts it with a cipher. In order to do that, the input text has to be in binary. I asked ChatGPT for help and it recommendeif ( Matches Reg Expr(input, "^[01]+$"), Show("Valid"), Show("Not Valid"));That doesn't work, and I'm trying to figure out why. I'm also trying to figure out a way to check if a number is in binary, so ...

  LatentHyena653

  Discussions |

  Feb 23, 2023 7:06 AM

  2109 views | 3 replies

• Profiler - Assess Variable Importance - "Variable importance requires at least two..."

  Hi!Quick question, I am having trouble identifying the root cause for the message "Variable importance requires at least two rows in the data table" that appears one and then even though the data table has about 10K rows, please advise. When using a similar dataset with mostly the same dimensions and using boosted trees, it works perfectly fine, however, if I change to another dataset, with mostly...

  RiztCL

  Discussions |

  Feb 22, 2023 6:20 AM

  1491 views | 2 replies