Welcome to the JMP User Community!

Latest Discussions

• How to shorten the script of opening 30 Excel files?

  Hi folks, I need to read data from 30 Excel files, and my current script is shown below, 383mm has 10 files, 533mm has 10 files and 683mm has 10 files. Is there any way to have a "for loop" type of script that can read all Excel files and assign all data to one stacked data table? Copy and paste 30 times to open 30 files seems awkward. Thanks for your help.  dt01 = Open( "E:_383mm_001/FRF.csv" );
  d...

  TDK_Long

  Discussions |

  Feb 27, 2023 3:54 PM

  1674 views | 3 replies

• Possible to change a single value in a string col box() list?

  Hi.  I'm wondering if there's a way to update a single item in a string col box()?  For example, is there a command like:scb = StringColBox("title", mylist); scb << Set Item(i, "newvalue"); //is there a cmd like this?I have a window with a string col box, and I would like my script to update a single value.  My current method:1. Get the entire list from the string col box2. Modify the list3. W...

  nikles

  Discussions |

  Feb 27, 2023 9:03 AM

  2016 views | 5 replies

• Table Update: How to update only selected columns?

  This should be a quick one:Table update: How to update only selected columns?  Data Table( dt1 ) << Update( With( Data Table( dt10 ) ), Match Columns( :SAMPLE = :SamID ), Add Columns from Update Table( None ),
### Update Selected Columns (:Type, :Method) ###
)It's simple when done manually, but in the script? There's nothing in the scripting guide (only how to avoid adding columns). My variou...

  Monomorphist

  Discussions |

  Feb 27, 2023 5:58 AM

  2064 views | 2 replies

• Set Cell Size with JSL

  I am trying to create an expression column in JMP12 that will hold images grabbed from a URL.  It is possible to define the cell size (width and height) using JSL?I have not gotten the width() property to work for an Expression column, but I find I can set the column width by first creating the column as a Character, and then changing the data type to Expression:dt << New Column( "Image", Characte...

  robot

  Discussions |

  Feb 27, 2023 5:57 AM

  10556 views | 3 replies

• Splitting survival curve

  JMP 17Dear all, I would appreciate your help with the following issue. I have a database of ca. 300 individuals split into 3 groups. The goal is to assess their survival over time. I have generated a Kaplan-Meier survival curve (max follow-up time 35 years) and log-rank is showing p<.05. Now I would like to split it and look into whether survival rates between those 3 groups differ at different ti...

  Nomeolvides1105

  Discussions |

  Feb 27, 2023 2:35 AM

  1619 views | 2 replies