nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I implement this "Copy With Column Names" operation with JSL?

lwx228

I did not find the manual. I tried：

dt << GetEditCopyLabel;
dt << GetEditCopyWithColumnNames;

but it was not successful.Thank you very much!

Accepted answers

Main Menu() should work. But before execution the data table must be moved to the front. Otherwise, "copy with column names" is not available in the Edit Menu.

Try this! (works in JMP 14 for Mac, possibly in other versions too)

// Before running, select columns and rows of interest, or deselect all to copy the whole table to clipboard
Current Data Table() << Bring Window To Front;
Wait(0);
Main Menu("Copy With Column Names");

txnelson

With luck, @ms may have a method using Main Menu().

However, the Copy Table option from a Table Box() is a universal option in JMP for any given table box in a report output. And in many cases, there are multiple table boxes in a given display. The method that I use to access a particular table box from a given report output from a JMP Platform, is to reference the Tree Structure table box that I need information from, and then sent it the message "<< Copy Data" (See Help==>Books==>Scripting Index==>Display Trees). The JSL below illustrates that method

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA\Boston Housing.jmp" );
pp = dt << Partition(
	Y( :mvalue ),
	X(
		:crim,
		:zn,
		:indus,
		:chas,
		:nox,
		:rooms,
		:age,
		:distance,
		:radial,
		:tax,
		:pt,
		:b,
		:lstat
	),
	Split Best( 3 )
);

Report( pp )[Table Box( 1 )] << copy data;

All comments

lwx228

Just copy data and column names to the paste board, thanks!

txnelson

I searched the Scripting Index for possible commands Copy with Column Names, and did not find an answer

Help==>Scripting Index==>Clipboard

I also tried using the Main Menu() function, that will bring up many of the commands from the Pull Down menus, but it did not work either.(See MS response below)

What are you planning to use the information you have copied into the Clipboard? There may be a solution if you could explain what you are going to be doing.

lwx228

I see. I'm not going to do that.
I am ready to transfer the results of JMP processing to excel and use VBA to further extract the desired results. VBA is very skilled.
Thank Jim!

gzmorgan0

As Jim stated, it is not clear what you are trying to do.

If you want a copy of the entire table:

CTRL+SHIFT+C , then CTRL+N (for a new table), then CTRL+SHIFT+V (simultaneous) keystrokes.
Table Subset can subset all rows and all columns Main Menu>Subset or using a script

current data table() << subset(All Rows, All Columns);

Main Menu() should work. But before execution the data table must be moved to the front. Otherwise, "copy with column names" is not available in the Edit Menu.

Try this! (works in JMP 14 for Mac, possibly in other versions too)

// Before running, select columns and rows of interest, or deselect all to copy the whole table to clipboard
Current Data Table() << Bring Window To Front;
Wait(0);
Main Menu("Copy With Column Names");

lwx228

It worked, thank you!

lwx228

Please give me the guidance again:

How to copy R square data table in this decision tree report in the form of Main Menu(), thank you!