- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
JSL code for summary table creation
im creating a summary table from dt1 called dt2. Code below. does anyone know the code for statistics column name format? i need it to be column stat.
I think when its default is stat(column), it throws off the join.
dt2 = dt1 << Summary(
Group(:lot),
Mean(:x, :y, :z),
Freq("None"),
Weight("None"),
Link to original data table(0),
statistics column name format("column stat")
);
dt1 << Update(
With(dt2),
Match Columns(:lot = :lot, ),
Add Columns from Update table(:Mean(x), :Mean(y), :Mean(z))
);
Thank you
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: JSL code for summary table creation
I edited your message to add JSL formatting and fixed missing , (maybe the missing , was issue you were having?). Create summary with JMP and then copy the script from Source table script
Data Table("Big Class") << Summary(
Mean(:height),
Mean(:weight),
Freq("None"),
Weight("None"),
statistics column name format("column stat")
)
-Jarmo