topic how to scrip 'make tabulate into data table' in Community Discussions

how to scrip 'make tabulate into data table'

Isabel26 — Wed, 10 Nov 2021 16:47:30 GMT

I think I am being nuts here. It should not be hard, but I just cannot make it work. I made a tabulate that I can click the option 'Make into data table', then save the data table. I want to script this so I can automate it. But no matter what I script, 'Make into data table' just won't work, either return me empty table, or error. Help is appreciated.

Re: how to scrip 'make tabulate into data table'

jthi — Wed, 10 Nov 2021 16:59:52 GMT

Create a tabulate, fron red triangle menu choose make into datatable, from new table check source table script (right click + edit). This should give you a good idea how to script it:

(Data Table("Big Class") << Tabulate(
	Show Control Panel(0),
	Add Table(
		Column Table(Analysis Columns(:weight), Statistics(Mean)),
		Row Table(Grouping Columns(:sex))
	)
)) << Make Into Data Table

Full example:

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
tab = dt << Tabulate(
	Show Control Panel(0),
	Add Table(
		Column Table(Analysis Columns(:weight), Statistics(Mean)),
		Row Table(Grouping Columns(:sex))
	)
);

dt_tab = tab << Make Into Data Table;
show(dt_tab);
//to close tabulate use
//tab << Close Window;

Re: how to scrip 'make tabulate into data table'

Isabel26 — Wed, 10 Nov 2021 17:21:22 GMT

It worked! Thanks. I guess if I want to add name to the new data table, I just need to add ' output table name( "NEW NAME")' some where?

Re: how to scrip 'make tabulate into data table'

jthi — Wed, 10 Nov 2021 17:27:42 GMT

I'm not sure but most likely you can add it like this:

dt_tab = tab << Make Into Data Table(Outputtable("test"));

and if that doesn't work you can set it after creation of the new table with:

dt_tab << Set Name("test");

Re: how to scrip 'make tabulate into data table'

Isabel26 — Wed, 10 Nov 2021 17:33:22 GMT

The first option works perfectly! Thanks so much!