Welcome to the JMP User Community!

Latest Discussions

• Disable "Update Table" script?

  After importing an Excel file, JMP adds a "Source" and an "Update Table" Script:   'Update Table' sounds like a script that can be used to update the JMP data table. After spending some hours working with a JMP data table, adding and grouping columns, and adding column properties... ... and having tried the 'Update Table' script, you will notice that all these changes are lost during the update.
  F...

  hogi

  Discussions |

  Nov 29, 2025 7:42 AM

  518 views | 3 replies

• JMP 18 new Update Table script overwrites table

  When importing Excel tables into JMP 18 I get two scripts 'Source' and 'Update Table' script, only difference seems to the an 'Update Table (1)' command. The second script performs an update from the Excel file, and overwrites any columns created after import. Is there a way to make it leave new columns alone when updating? Did not find anything in the Scripting Index.

  Ake

  Discussions |

  Nov 29, 2025 7:35 AM

  1439 views | 3 replies

• Add variable in Graph builder

  I have data table with multiple columns and rows I want to loop through each column and add it to graph builder on x -axis  This is my simple script    dt = Open( filepath ); all_cols = dt << Get Column Names( "String" ); cols_to_plot={}; For Each ({col}, all_cols,            If(col == "A" || col == "B",,                         Insert into (cols_to_plot, col);                ) ); graph = dt << ...

  ravij

  Discussions |

  Nov 28, 2025 11:28 AM

  460 views | 8 replies

• Choice Design for Mode Choice

  Hi everyone, I’m relatively new to SAS JMP, and I’m currently trying to design a discrete choice experiment (DCE) for my research. I need to create a set of choice scenarios where respondents choose between four transportation modes: car, motorcycle, bus, and train. Each mode has different attributes and levels, as shown below: 1. Car Travel time: 40, 60, 80 Travel cost: 45,000; 55,000; 75,000 ...

  Bravoadam18

  Discussions |

  Nov 28, 2025 6:23 AM

  242 views | 3 replies

• Issues with Update() on floating-point EFT values

  I am merging sample-level metadata with time-series raw measurements using Python’s merge_asof and then updating the time-series table in JMP using Update(). Both tables contain columns for time (EFT) and batch ID. The problem: After the Python merge, the resulting table (merged_samples) contains exact matches for some time points and “nearest” matches for others. Python merge handles “nearest” ...

  zetaVagabond1

  Discussions |

  Nov 28, 2025 4:28 AM

  427 views | 9 replies