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=""></COPY>
Thanks, I had no idea one could select entries from the menu like that... works like a charm!
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);