cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
View Translated Thread
terapin
terapin
Level VI

JSl Code to Delete Column Referenced By Formula

Jan 3, 2011 11:52 AM (15233 views)
I'm trying to delete a column in JSL. However, the column to be deleted is used by another column in a formula. I can't find the syntax for JSL to remove the formula when I delete the column. Any ideas how to accomplish this would be appreciated.
0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
Solution

Re: JSl Code to Delete Column Referenced By Formula

Created: Jan 3, 2011 12:21 PM  |  Last Modified: Mar 7, 2018 6:08 AM (17841 views)  |  Posted in reply to message from terapin 01-03-2011

You should delete the formula referencing the column first:

Column("column name") << delete formula;

Then delete the column.

View solution in original post

2 REPLIES 2
Solution

Re: JSl Code to Delete Column Referenced By Formula

Created: Jan 3, 2011 12:21 PM  |  Last Modified: Mar 7, 2018 6:08 AM (17842 views)  |  Posted in reply to message from terapin 01-03-2011

You should delete the formula referencing the column first:

Column("column name") << delete formula;

Then delete the column.

terapin
terapin
Level VI

Re: JSl Code to Delete Column Referenced By Formula

Jan 5, 2011 10:40 AM (14512 views)  |  Posted in reply to message from terapin 01-03-2011
Thanks. That was rather simple and easy.
0 Kudos