Welcome to the JMP User Community!

Latest Discussions

• Add File Name and Date in Import Settings

  I would like some input on how to include adding File Name and File Date in import settings.  In typical Multiple File Import, we have  <<Set Add File Name Column( 1 ), <<Set Add File Size Column( 0 ), <<Set Add File Date Column( 1 ), However, this will not work in my case. So I tried using New Column () function, but it gives empty columns or no column "Source File" at all.   For(i = 1, i <= ...

  Azim

  Discussions |

  Dec 1, 2025 3:09 AM

  196 views | 2 replies

• 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

  549 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

  1494 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

  579 views | 8 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

  510 views | 9 replies