Convert tab headers in tabulate to column groups JMP19

SophieCuvillier

Hello,

 

In JMP19 there is very nice new functionality where grouping columns create column headers in the data table.

Thus, we wanted to know if when we do a tabulate , and we do "Make into data table" , can we keep the headers ?

I know we can keep the headers as tags, but otherwise can I transform the tags to group columns?

 

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Tabulate(
	Add Table(
		Column Table( Grouping Columns( :sex, :marital status ) ),
		Row Table( Grouping Columns( :country, :size ) )
	)
);

tbl = obj << make into data table();

jthi

You could build them from column properties (there definitely should be << Get Tags or something similar)

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Car Poll.jmp");
tab = dt << Tabulate(
	Add Table(
		Column Table(Grouping Columns(:sex, :marital status)),
		Row Table(Grouping Columns(:country, :size))
	)
);

dt_tab = tab << make into data table;

tags = {};
For Each({colname}, dt_tab << Get Column Names("String"),
	prop = Column(dt_tab, colname) << Get Property("Tags");
	If(!Is Empty(prop),
		Insert Into(tags, prop);	
	);
);

And build it from there while taking into account the hierarchy of the groups.

Other option could be to utilize Full Path Column Name(1) but it does affect the column names (and tags)