cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar

Copy selected data to clipboard for further processing by user

My use case:

- Original data needs to be transposed and can contain information on N samples

- In most - but not all - cases the data of interest is in the first row of the transposed data

- Of the copied rows, not all columns should be copied, only the ones namens "Row 3, Row 4, Row 5" (the columns are named row because of the transpose).

- This data needs to be copied to the clipboard for further processing. This can by pasting into another JMP table or somewhere else.

 

The first steps are very trivial, however, copying the data to the clipboard seems not to work. I have tried (many) variants of the following:

Names Default To Here( 1 );
dt = Current Data Table();
Tdt = dt << Transpose( columns( :"1st Thickness"n ), By( :FOUP SLOT ), Output Table() );

Tdt << Select Rows( [1] ) << Select Columns(
	 :Row 3, :Row 4, :Row 5
)<<Copy Selected Table Row();

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Copy selected data to clipboard for further processing by user

Copy Selected Table Rows() doesn't seem to work with Datatables but with Table Boxes and datatable boxes

 

You could use the Copy With Full Precision found from Edit menu:

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
col_list = {"age", "name", "height"};
dt << Select Rows([1]) << Select Columns(col_list);
Main Menu("Copy With Full Precision", dt << get name);
-Jarmo

View solution in original post

2 REPLIES 2
jthi
Super User

Re: Copy selected data to clipboard for further processing by user

Copy Selected Table Rows() doesn't seem to work with Datatables but with Table Boxes and datatable boxes

 

You could use the Copy With Full Precision found from Edit menu:

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
col_list = {"age", "name", "height"};
dt << Select Rows([1]) << Select Columns(col_list);
Main Menu("Copy With Full Precision", dt << get name);
-Jarmo

Re: Copy selected data to clipboard for further processing by user

Thanks, I had no idea one could select entries from the menu like that... works like a charm!