Does anyone know a way to keep a data table linked to the excel file it was orginally created from?
I need to be able to refresh the data table to capture any changes or new rows in the excel file.
I used Database > Open Table to create the table originally, and can see the script, but the option to run is greyed out.
Thanks for any help.
i tried the suggestion, and have it creating a new table. if I'm trying to keep a number of calculations (columns) running off the original data set, is there a way to replace the column data rather than create a new table?
i am not aware of udating a jmp table with a colum in excel. what i would do is import the updated excel file and then use "tables >> update" or "tables >> join" in jmp.
hope it helps
You can add JSL code to your import script to create new columns which recreate the formulas you are using. An out of context example:
New Column( "Oxy times Age",
Format( "Best", 12 ),
Formula( :Oxy * :Age )
If you do this then you will always be importing the whole Excel file and recalculating the formula columns.
Take a look at the "An Example: Automating JMP From Excel 2007" section of Chapter 10 in the JMP 9 Scripting Guide. This example demonstrates how a JMP data table (originating from Excel) can be updated automatically when individual cells are changed in the Excel worksheet.
Hope that helps!