Welcome to the JMP User Community!

Latest Discussions

• Split Array

  Hi, 1. Any ideas how to split a = {"c", "d","e"}; into a= {"c"}, {"d"},{"e"}; ? Currently when I did Concat Items (a, ","); , the output will be "c,d,e" instead of "c","d","e" . 2. Concat Items did apply after letter c. However, what if I want to concat "," before c such as ",c,d,e"? 3. Is there any possibilities to combine semicolon together with other strings? For example, " " "|| water || bend ...

  WanCine

  Discussions |

  Jan 14, 2021 6:33 AM

  2711 views | 4 replies

• How can get the result of the formula calculated with multiple columns directly from the computation of an array in memory?

  The requirements for calculation with the data of "Big Class.jmp" and formula are as follows:
  Add column "row6" and find the minimum height from row 10 and up to 6 rows;
  Add column "row7" and find the minimum value of the height column starting from row 10 and up to 7 rows;
  ...
  How to find the result of "row6" -- "row9" directly by using memory array method?Thanks!dt=Open("$SAMPLE_DATA/Big Class.jmp")...

  lwx228

  Discussions |

  Jan 14, 2021 1:13 AM

  2738 views | 5 replies

• CUSUM Control Chart

  hi guys,   If I take the data set from the sample data library "Engine Temperature Sensor.jmp." and run the script below, I detect a shift at datapoint 26. What I would like to do is to modify the script below,so upon a shift detection only, it would automatically do something (example trigger an email, or write to a file ) flagging a shift was detected and on which data point the shift occurred? ...

  BrianK

  Discussions |

  Jan 13, 2021 10:25 AM

  2401 views | 3 replies

• Change date format in a script

  I have a script that requires the user to input a batch creation time. It currently looks like this:  New Window( "BATCH_CREATE_TIME", <<modal(), Panel Box( "Enter BATCH_CREATE_TIME", Lineup Box( N Col( 1 ) ), number = Text Edit Box( "01/01/2021 09:00:00.000000" ) ), Panel Box( "Actions", H List Box( Button Box( "OK", keep_going = 1; BATCH_TIME = number << Get text; ), B...

  HarriBradbeer

  Discussions |

  Jan 12, 2021 9:55 AM

  1839 views | 1 replies

• How to replace selected values in a column with JSL

  Hi everyone,  I'm looking to replace alternate values in a column in using scripting. I've managed to select the values in the table but I'm struggling to find a way to replace them in just 1 column only.  This is my code so far: Names Default To Here (1);
dt << new column ("selection", formula (sequence (1,2,1 ))); dt:selection << delete formula; dt << select where(:1 & :selection !=1); This is t...

  ASullivan

  Discussions |

  Jan 12, 2021 8:13 AM

  5905 views | 7 replies