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;
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:
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)
)
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:
Thank you, I tried it and it works for me. I appreciate you, you saved my day. Please mark it as a solution.