topic Re: Run saved scripts after a data table update in Discussions

Run saved scripts after a data table update

frankderuyck — Thu, 07 Nov 2019 17:56:57 GMT

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

Re: Run saved scripts after a data table update

Mark_Bailey — Thu, 07 Nov 2019 18:01:01 GMT

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.

Re: Run saved scripts after a data table update

frankderuyck — Fri, 08 Nov 2019 07:29:29 GMT

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

Re: Run saved scripts after a data table update

txnelson — Fri, 08 Nov 2019 09:12:28 GMT

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.

Re: Run saved scripts after a data table update

frankderuyck — Fri, 08 Nov 2019 10:07:43 GMT

Thanks Jim! Frank