712499_en-US

liliconcom

Hide columns script

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;

Automation and ScriptingRe: Hide columns script

Try this

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

dt<<GET selected="" columns=""></GET>

Re: Hide columns script

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

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