cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
Isabel26
Level III

how to scrip 'make tabulate into data table'

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.

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
jthi
Super User

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

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;
-Jarmo

View solution in original post

jthi
Super User

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

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");
-Jarmo

View solution in original post

4 REPLIES 4
jthi
Super User

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

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;
-Jarmo
Isabel26
Level III

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

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?

jthi
Super User

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

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");
-Jarmo
Isabel26
Level III

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

The first option works perfectly! Thanks so much!