Created:
Jan 3, 2024 04:27 PM
| Last Modified: Jan 4, 2024 7:04 AM890 views
Copy Columns from the right-click context menu of a column header is very useful. Just copy the column(s) - with all the settings ... and paste it into a JSL script - or another table.
There is a hidden feature: When rows are selected, the values of the selected rows are used as arguments of the Set Values() command and will populate the cells of the new column.
So, when you select all rows before copying a column it's a very convenient way to clone a column .
On the other hand, if only a few rows are selected, the functionality leads to surprising results:
The first N rows of the new column get populated with the N selected values (!).
For formula columns, the command doesn't have an effect.
So, after copying a column and pasting it into a JSL script, generally my next task is: delete the Set Values(...)[together with the Set Selected ]. Or better: undo the first "paste" - deselect the rows - copy the column again and paste it without the Set Values() command.
On the third hand, I guess there is a cool use case for this functionality - but I have not found it yet ...
Any ideas?
Copy_Column.mp4
Video Player is loading.
Current Time 0:00
/
Duration 0:11
Loaded: 0%
0:00
Stream Type LIVE
Remaining Time -0:11
1x
Chapters
descriptions off, selected
captions settings, opens captions settings dialog
captions off, selected
en (Main), selected
This is a modal window.
Beginning of dialog window. Escape will cancel and close the window.
End of dialog window.
This is a modal window. This modal can be closed by pressing the Escape key or activating the close button.
These videos provide JMP essentials for new users and those who want a refresher. Overviews Getting Started With JMP JMP Tips and...