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%26lt%3B%20ingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22lingo-body-247296%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EColSpanBox%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%99%E3%82%8B%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%83%9C%E3%83%83%E3%82%AF%E3%82%B9%E3%81%A7%E3%80%81%60%26lt%3B%E3%81%A8%E5%AF%BE%E8%A9%B1%E3%81%99%E3%82%8B%E3%81%A8%E3%81%8D%E3%81%AB%E5%88%97%E3%81%AB%E9%81%A9%E5%88%87%E3%81%AA%E5%90%8D%E5%89%8D%E3%82%92%E4%BB%98%E3%81%91%E3%81%9F%E3%81%84%E3%80%82%20%3CMAKE%20into%3D%22%22%20data%3D%22https%3A%2F%2Fcommunity.jmp.com%2F%22%20table%3D%22%22%3E%3C%2FMAKE%3E%3C%2FP%3E%3CP%3E%20%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%3Etabulate%20%E3%81%AE%E5%8B%95%E4%BD%9C%E3%81%AF%E7%A7%81%E3%81%AB%E3%81%A8%E3%81%A3%E3%81%A6%E3%81%AF%E5%95%8F%E9%A1%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%9B%E3%82%93%E3%80%82%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%20%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%20%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%0A%3CP%3E%20%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%3E%E8%87%AA%E5%8B%95%E5%8C%96%E3%81%A8%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FMAKEINTODATATABLE%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