Choose Language Hide Translation Bar
frankderuyck
Community Trekker

Run saved scripts after a data table update

Hi, I saved a lot of scripts in a data table that I want to keep using after a major update of my data matrix, is this possible? How?

Thanks for advice, Frank

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Run saved scripts after a data table update

If you create a new data table by reading in new data from an Excel file, you can copy and paste the scripts from your old data table, to your new data table.  All of the scripts will continue to work, as long as the columns in the new data table are named the same, and have the same characteristics as the old data table.

You can also copy each of the scripts from the old data table, to JMP script files, .JSL files, and run them from there against the new data table.  The same thing will hold true, that columns that are referenced in the scripts will have to be in the new data table.

Jim

View solution in original post

4 REPLIES 4

Re: Run saved scripts after a data table update

What is stopping you from using them? At any time, the table scripts will evaluate using the current state of the data table. Click the green triangle next to the script name in the Table panel. If you are using an older version with red triangles, click it and select Run Script.

Learn it once, use it forever!
0 Kudos
frankderuyck
Community Trekker

Re: Run saved scripts after a data table update

I know Mark, but what if I get an updated Excel data file that I have to import in JMP?

0 Kudos
txnelson
Super User

Re: Run saved scripts after a data table update

If you create a new data table by reading in new data from an Excel file, you can copy and paste the scripts from your old data table, to your new data table.  All of the scripts will continue to work, as long as the columns in the new data table are named the same, and have the same characteristics as the old data table.

You can also copy each of the scripts from the old data table, to JMP script files, .JSL files, and run them from there against the new data table.  The same thing will hold true, that columns that are referenced in the scripts will have to be in the new data table.

Jim

View solution in original post

Highlighted
frankderuyck
Community Trekker

Re: Run saved scripts after a data table update

Thanks Jim! Frank
0 Kudos