cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Have your say in shaping JMP's future by participating in the new JMP Wish List Prioritization Survey
Choose Language Hide Translation Bar
terapin
Level VI

JSl Code to Delete Column Referenced By Formula

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.
1 ACCEPTED SOLUTION

Accepted Solutions

Re: JSl Code to Delete Column Referenced By Formula

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

Re: JSl Code to Delete Column Referenced By Formula

You should delete the formula referencing the column first:

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

Then delete the column.

terapin
Level VI

Re: JSl Code to Delete Column Referenced By Formula

Thanks. That was rather simple and easy.