script - delete or reorder colums

cz1 — Wed, 27 Aug 2025 07:34:44 GMT

hi,

I would like to add "delete multiple columns" or "reorder multiple columns" to my script.

How can I code this into my scripts?

JMP help provides a simple description for a single column, but I can't do it manually for more than 100 columns.

Thank you in advance

A++

Zdenek

dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt:height << Set Selected;
Wait(2);
dt << Delete Columns();

Edit (jthi): added jsl formatting

Re: script - delete or reorder colums

jthi — Wed, 27 Aug 2025 07:39:18 GMT

Do you wish to reorder/delete columns based on user-selection or list in the script?

Using list (Delete Columns )

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");

cols_to_delete = {"height", "weight", "age"};
dt << Delete Columns(cols_to_delete);

Selection

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");
cols_to_delete = {"height", "weight", "age"};
dt << Select columns(cols_to_delete);
dt << Delete Columns();

Reordering

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");
cols_to_reorder = {"height", "weight", "age", "name"};
dt << Move Selected Columns(cols_to_reorder, To Last);

JMP's Scripting Index does sometimes have nice examples so it is a good starting point when scripting JMP.

topic Re: script - delete or reorder colums in Discussions

script - delete or reorder colums

Re: script - delete or reorder colums