cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
saitcopuroglu
Level IV

How to set name of a table created by tabulate

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
ms
Super User (Alumni) ms
Super User (Alumni)

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

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

View solution in original post

2 REPLIES 2
ms
Super User (Alumni) ms
Super User (Alumni)

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

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
Level IV

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

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.