cancel
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
%3CLINGO-SUB%20id%3D%22lingo-sub-2789%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EJSl%20Code%20to%20Delete%20Column%20Referenced%20By%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2789%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EI'm%20trying%20to%20delete%20a%20column%20in%20JSL.%20However%2C%20the%20column%20to%20be%20deleted%20is%20used%20by%20another%20column%20in%20a%20formula.%20I%20can't%20find%20the%20syntax%20for%20JSL%20to%20remove%20the%20formula%20when%20I%20delete%20the%20column.%20Any%20ideas%20how%20to%20accomplish%20this%20would%20be%20appreciated.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2791%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20JSl%20Code%20to%20Delete%20Column%20Referenced%20By%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2791%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EThanks.%20That%20was%20rather%20simple%20and%20easy.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2790%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20JSl%20Code%20to%20Delete%20Column%20Referenced%20By%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2790%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EYou%20should%20delete%20the%20formula%20referencing%20the%20column%20first%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EColumn(%22column%20name%22)%20%26lt%3B%26lt%3B%20delete%20formula%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EThen%20delete%20the%20column.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.