cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-247296%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%26lt%3B%3CMAKEINTODATATABLE%20name%3D%22%22%20better%3D%22%22%20when%3D%22%22%20used%3D%22%22%20with%3D%22%22%20colspanbox%3D%22%22%3E%3C%2FMAKEINTODATATABLE%3E%3CLINGO-BODY%20id%3D%22lingo-body-247296%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EI%20want%20tableboxes%20that%20use%20ColSpanBox%20to%20name%20the%20columns%20better%20when%20interacting%20with%20%60%26lt%3B%3CMAKE%20into%3D%22%22%20data%3D%22https%3A%2F%2Fcommunity.jmp.com%2F%22%20table%3D%22%22%3E%0A%3C%2FMAKE%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Edt%20%3D%20Open(%22%24SAMPLE_DATA%5CBig%20Class.jmp%22)%3B%0A%0Anew%20window(%22Row%20Borders%22%2C%20%0A%09tblbox%20%3D%20tablebox(%0A%09%09ColSpanBox(%221%22%2C%20%0A%09%09%09NumberColBox(%22age%22%2C%20dt%3Aage%20%26lt%3B%26lt%3B%20Get%20Values)%2C%0A%09%09%09StringColbox(%22Sex%22%2C%20dt%3Asex%20%26lt%3B%26lt%3B%20Get%20Values)%2C%20%0A%09%09)%2C%0A%09%09NumberColBox(%22Height%22%2C%20dt%3Aheight%20%26lt%3B%26lt%3B%20Get%20Values)%0A%09)%0A)%3B%0A%0Atblbox%20%26lt%3B%26lt%3B%20Make%20into%20data%20table()%3B%0A%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EThe%20behavior%20that%20tabulate%20does%20would%20be%20fine%20by%20me.%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E(dt%20%26lt%3B%26lt%3B%20Tabulate(%0A%09Add%20Table(%20Column%20Table(%20Grouping%20Columns(%20%3Asex%2C%20%3Aage%20)%20)%20)%0A))%20%26lt%3B%26lt%3B%20Make%20Into%20Data%20Table%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-247296%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CLINGO-LABEL%3EAutomation%20and%20Scripting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FLINGO-SUB%3E
Choose Language Hide Translation Bar

<<makeintodatatable name better when used with colspanbox

I want tableboxes that use ColSpanBox to name the columns better when interacting with `<<make into data table`.  Currently it just takes the lowest column name.  

 

dt = Open("$SAMPLE_DATA\Big Class.jmp");

new window("Row Borders", 
	tblbox = tablebox(
		ColSpanBox("1", 
			NumberColBox("age", dt:age << Get Values),
			StringColbox("Sex", dt:sex << Get Values), 
		),
		NumberColBox("Height", dt:height << Get Values)
	)
);

tblbox << Make into data table();

The behavior that tabulate does would be fine by me.   

 

 

(dt << Tabulate(
	Add Table( Column Table( Grouping Columns( :sex, :age ) ) )
)) << Make Into Data Table