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%3E%60%26lt%3B%EC%99%80%20%EC%83%81%ED%98%B8%20%EC%9E%91%EC%9A%A9%ED%95%A0%20%EB%95%8C%20ColSpanBox%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20%EC%97%B4%20%EC%9D%B4%EB%A6%84%EC%9D%84%20%EB%8D%94%20%EC%9E%98%20%EC%A7%80%EC%A0%95%ED%95%98%EB%8A%94%20%ED%85%8C%EC%9D%B4%EB%B8%94%20%EC%83%81%EC%9E%90%EB%A5%BC%20%EC%9B%90%ED%95%A9%EB%8B%88%EB%8B%A4.%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%3E%ED%91%9C%EB%A1%9C%20%EB%A7%8C%EB%93%9C%EB%8A%94%20%ED%96%89%EB%8F%99%EC%9D%80%20%EA%B4%9C%EC%B0%AE%EC%9D%84%20%EA%B2%83%EC%9E%85%EB%8B%88%EB%8B%A4.%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%EC%9E%90%EB%8F%99%ED%99%94%20%EB%B0%8F%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8C%85%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