topic Re: How to set name of a table created by tabulate in Discussions

How to set name of a table created by tabulate

saitcopuroglu — Thu, 07 May 2015 06:44:19 GMT

Hi all,

I create a table through tabulate and each time it gets a name of "untitled xxx", however I would like to set a name for it for further reportings. The script is:

(Data Table( "AnnualFinancial.jmp" ) << Tabulate(

Remove Column Label( Grouping Columns( :Type ) ),

Show Chart( 1 ),

Show Control Panel( 0 ),

Uniform plot scale( 0 ),

Add Table(

Column Table( Analysis Columns( :Adult Night Year ), Statistics( Mean ) ),

Column Table( Analysis Columns( :G.O.P. ), Statistics( Mean ) ),

Column Table( Analysis Columns( :Total € ) ),

Column Table(

Analysis Columns( :Total € ),

Grouping Columns( :Type ),

Statistics( Row % )

Row Table( Grouping Columns( :Year ) )

)

)) << Make Into Data Table;

Thank you in advance

Re: How to set name of a table created by tabulate

ms — Thu, 07 May 2015 07:43:20 GMT

Quick fix:

(...your code...) << set name("my name");

Better: By assigning variables to your tables and reports it will be much easier to understand, improve, expand and bug fix your code. In the example below the final table does not only get a name but also a variable that, in my experience, is more useful for "further reportings" than a name.

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");

tab = dt << Tabulate(

Add Table(Column Table(Analysis Columns(:height), Statistics(Mean)), Row Table(Grouping Columns(:sex)))

);

dt_tab = tab << make into datatable;

dt_tab << set name("my name");

tab<<close window; // variables for windows simplifies cleaning up the workspace, among other...

Re: How to set name of a table created by tabulate

saitcopuroglu — Thu, 07 May 2015 08:11:34 GMT

Ohh true, sometimes I freeze, the actual script is working on actual data table, a simple rule.

Thank you for your reply. I will try to organise them by assigning variables, they are a little hard to track for a beginner though..

Many thanks again.