cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Use World Cup data to build models, explore spatial relationships, and create informative visualizations in JMP. Register. July 17, 2 pm US Eastern Time.
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
jthi
Super User

Collapsing Table Variables/Scripts from Data Box

Is there a way to collapse Table Variables/Scripts from Data Box / change height of Columns list to hide it? Or is there any other way of getting column listing from data table with same functionalities? 

What I have:

jthi_0-1663155811839.png

What I would like to have:

jthi_1-1663155822022.png

 

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp", invisible);

New Window("Big Class",
	H List Box(
		lb = List Box(dt << Get Column Names("String"),
			dt << Select Columns(lb << Get Selected);
		),
		H List Box(dg = dt << New Data Box())
	)
);
dg << close data grid(1);

I could try hiding it with Padding but that sounds like more trouble than I really want

View more...
Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp", invisible);

New Window("Big Class",
	H List Box(
		lb = List Box(dt << Get Column Names("String"),
			dt << Select Columns(lb << Get Selected);
		),
		Border Box(Sides(15),
			H List Box(dg = dt << New Data Box(), Text Box(" asdasd"))
		)
	)
);
dg << close data grid(1);
dg << Set Auto Stretching(0,0);
dg << Padding(Left(0), Top(-210), Right(0), Bottom(0));
 

 

-Jarmo
2 REPLIES 2
pauldeen
Level VI

Re: Collapsing Table Variables/Scripts from Data Box

Have you tried a Col List Box with the grouped property turned on?

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
Data Table( "Big Class" ) << Group Columns( "height etc.", {:height, :weight} );
New Window( "Col List Box Example 1", Col List Box( all, width( 250 ), grouped, maxSelected( 1 ) ) );
jthi
Super User

Re: Collapsing Table Variables/Scripts from Data Box

Col List Box is missing some of the features I would like to have, such as showing columns which have been excluded and hidden.

-Jarmo

Recommended Articles