topic Re: Hide columns script in Discussions

Hide columns script

Tavuk89 — Wed, 27 Dec 2023 00:16:19 GMT

I tried this script to hide column no.1,2,3 but it only select the columns without hiding them. What did i missed?

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
c= dt << Select Columns( [1.2.3] );
c << Hide;

Re: Hide columns script

txnelson — Wed, 27 Dec 2023 03:09:22 GMT

Try this

names default to here(1);
dt=current data table();

dt<<get selected columns;

for each( {col}, dt<<get selected columns,
	as column(col) << hide(0)
)

Re: Hide columns script

jthi — Wed, 27 Dec 2023 07:57:25 GMT

To hide columns I think you have to hide them one by one so loop over that matrix rather than select the columns.If you have JMP16+ you can use For Each, otherwise change that to "normal" for-loop

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
col_idx = [1, 2, 3];

For Each({idx}, col_idx,
	Column(dt, idx) << Hide(1);
);

From scripting index:

Re: Hide columns script

TaraHaley — Wed, 24 Jan 2024 09:51:26 GMT

Thank you, I tried it and it works for me. I appreciate you, you saved my day. Please mark it as a solution.