Subscribe Bookmark RSS Feed

How to set name of a table created by tabulate

saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

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

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

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...

2 REPLIES
Solution

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...

saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

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.