Scripting - formulas are recorded, but not other steps such as "creating and renaming new columns".

carolinesanden

Hi,

I am quite new to JMP and have tested the scripting function. I want the script to do following:

1. Import an excel document

2. Create and rename new columns

3. Assign formulas to the columns

 

I start by clearing the log file and then proceed with steps 1-3, but somehow only step 3 is recorded and can be saved as a script. I am greatful for any suggestions about how to move forward (preferably an interactive explanation).

 

Best regards,

Caroline

txnelson

What version of JMP are you using?

JMP 16 has expanded the ability to capture the details of table manipulation to the log.  Prior to that, one had to write more JSL.

However, your step 1 is there, you just have to know where it is.  After you have opened your Excel file, go to the Data table, and right click on the green triangle that is next to the word "Source" in the tables panel on the upper left side of the display.  It contains the JSL required to import the Excel file.

Next, you can create the new columns interactively, and apply the formulas using the formula editor.  Then if you right click on the the red triangle in the same Table Panel, you can select Copy Table Script.  If you then open a new script window, and paste the copied table script into the window, you will see the JSL required to create those new columns and formulas.