Welcome to the JMP User Community!

Latest Discussions

• Automatic Recalc on block of code?

  Context: JMP 17 Hi all, I am working on a dashboard project where I use a function to generate a bunch of different plots that get stuffed into a big grid for the user to browse. That function handles the plot generation and has its own Where() clause to select from a larger data table which contains lots of other data. The grid of plots then sit inside a local data filter so I can do some high le...

  TheSource

  Discussions |

  Dec 2, 2025 10:47 AM

  258 views | 3 replies

• 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

  194 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

  1492 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