topic Get the title from a number col box in Discussions

Get the title from a number col box

shampton82 — Fri, 09 Jun 2023 18:13:47 GMT

Okay so just starting to dive into Tree navigation and I have this simple script that I'm experimenting with:

names default to here(1);

dt=current data table();

//this is a partition analysis
actobj=Current Report()[outlinebox(1)]<<get scriptable object;

actobjrpt=actobj<<report;

//this links to the Logworth value from the first split
actobjtable = actobjrpt[numbercolbox( 7 )][1];

So I can get the value of the Logworth but I also want to get the title from the numbercolbox which is "Logworth". So far I can't figure it out. Thanks for any suggestions!

Steve

Re: Get the title from a number col box

txnelson — Sun, 20 Mar 2022 21:40:44 GMT

Here is one way to get what you want

names default to here(1);

// Open Data Table: big class.jmp
// → Data Table( "big class" )
dt = Open( "/C:/Program Files/SAS/JMPPRO/14/Samples/Data/big class.jmp" );

Partition(
	Y( :height ),
	X( :age, :sex, :weight ),
	Informative Missing( 1 ),
	Initial Splits( :weight < 81, {}, {:age == {12, 13}} ),
	SendToReport(
		Dispatch( {}, "Partition Report", FrameBox, {Frame Size( 480, 62 )} )
	)
);

//this is a partition analysis
actobjrpt=Current Report();

actobjrpt=actobj<<report;

//this links to the Logworth value from the first split
actobjtable = (actobjrpt[numbercolbox( 7 )]<<get)[1];

// get the header
theHeader = actobjtable = actobjrpt[numbercolbox( 7 )]<<get heading;

show(actobjtable, theHeader);

Re: Get the title from a number col box

Craige_Hales — Sun, 20 Mar 2022 21:45:37 GMT

see if the <<GetHeading message is the one you need.

Scripting index example for Get Heading.

Re: Get the title from a number col box

shampton82 — Sun, 20 Mar 2022 21:49:10 GMT

I was so close! I tried "Get" and "Get Title" then gave up and came here as there are a million get commands.

Thanks for the quick rely!

Steve