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