cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar

JSL implementation of merged cell display format similar to the tabulation function. JMP17

When generating reports using JSL, I want to place a table in a new window that resembles the style displayed by the 【Tabulate】 function (where cells with the same column values can be merged). The data for the report comes from a JMP table.

【My Challenges】
JMP17
1. When I use a new window and add a table box, each row displays data, but cells with the same category are not merged. Is there a method in JSL to achieve a display similar to merging cells in Excel?
2. Additionally, is it possible to customize the dividing lines of the table? (Where the dividing lines appear and their format)
2 REPLIES 2
hogi
Level XIII

Re: JSL implementation of merged cell display format similar to the tabulation function. JMP17

can you use Tabulate in your report?

jthi
Super User

Re: JSL implementation of merged cell display format similar to the tabulation function. JMP17

You cannot (easily) do cell merging in table box. Like hogi did already ask, could you just use the tabulate in your new window/report? 

Most of the things you can do with table box, can be found from Scripting Index

jthi_0-1759135704698.png

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Car Poll.jmp");

nw = New Window("",
	H List Box(
		Distribution(Continuous Distribution(Column(:age))),
		tab = dt << Tabulate(
			Show Control Panel(0),
			Add Table(
				Column Table(Grouping Columns(:sex, :marital status)),
				Row Table(Grouping Columns(:country, :size))
			)
		)		
	)
);

Scripting Guide > Display Trees > Construct Custom Windows > Examples of Creating a Dashboard from T... 

 

There are also some options outside of table box (such as using lineup box) but those generally do require more scripting.

-Jarmo

Recommended Articles