- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Make Into Data Table not working in Script
I'm running into issues trying to script making a Tabulate object into a new data table. I've tried both syntaxes below, but neither creates the table. I'm using this as one step in a larger workflow.
t2 = tbl << Tabulate(
Add Table(
Column Table( Grouping Columns( :Treatment ) ),
Row Table(
Analysis Columns(
:"Attribute 1"n,
:"Attribute 2"n,
:"Attribute 3"n,
:"Attribute 4"n,
:"Attribute 5"n, :"Attribute 6"n,
:"Attribute 7"n, :"Attribute 8"n,
:"Attribute 9"n,
:"Attribute 10"n, :"Attribute 11"n
),
Statistics( Mean )
)
),
Local Data Filter(
Mode( Show( 0 ) ),
Add Filter( columns( :A or B), Where( :A or B == "A" ) )
),
)) << Make Into Data Table();
and
t2 = tbl << Tabulate(
Add Table(
Column Table( Grouping Columns( :Treatment ) ),
Row Table(
Analysis Columns(
:"Attribute 1"n,
:"Attribute 2"n,
:"Attribute 3"n,
:"Attribute 4"n,
:"Attribute 5"n, :"Attribute 6"n,
:"Attribute 7"n, :"Attribute 8"n,
:"Attribute 9"n,
:"Attribute 10"n, :"Attribute 11"n
),
Statistics( Mean )
)
),
Local Data Filter(
Mode( Show( 0 ) ),
Add Filter( columns( :A or B), Where( :A or B == "A" ) )
),
));
Wait(1);
t2 << Make Into Data Table();
I'm on JMP 17.2.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Make Into Data Table not working in Script
Hm, interesting.
In the first example, when you add some brackets it should work. Without the brackets you send the message to the table and not to the Tabulate object.
Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
(dt << Tabulate(
Add Table(
Column Table( Analysis Columns( :height ) ),
Row Table( Grouping Columns( :sex ) )
)
)) << Make Into Data Table();
The second option should work. Maybe there is a typo?
The easiest way:
use the gui, then go to the log and "steal the code" .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Make Into Data Table not working in Script
Hm, interesting.
In the first example, when you add some brackets it should work. Without the brackets you send the message to the table and not to the Tabulate object.
Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
(dt << Tabulate(
Add Table(
Column Table( Analysis Columns( :height ) ),
Row Table( Grouping Columns( :sex ) )
)
)) << Make Into Data Table();
The second option should work. Maybe there is a typo?
The easiest way:
use the gui, then go to the log and "steal the code" .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Make Into Data Table not working in Script
Adding the parentheses fixed it - all these issues were just from a typo. Thank you!