Appendix D. Spoon Shortcuts

The following tables summarize the main Spoon shortcuts. Have this appendix handy; it will save a lot of time while working with Spoon.

Note

If you are a Mac user, please be aware that a mixture of Windows and Mac keys is used. Thus, the shortcut keys are not always what you expect. For example, in some cases you copy with Ctrl+C, while in others you do it with Command+C.

General shortcuts

The following table lists general Spoon shortcuts:

Action	Shortcut
New job	Ctrl+Alt+N
New transformation	Ctrl+N
Open a job/transformation	Ctrl+O
Save a job/transformation	Ctrl+S
Close a job/transformation	Ctrl+F4
Run a job/transformation	F9
Preview a transformation	F10
Debug a transformation	Shift+F10
Verify a transformation	F11
Job settings	Ctrl+J
Transformation settings	Ctrl+T
Search metadata	Ctrl+F
Set environment variables	Ctrl+Alt+J
Show environment variables	Ctrl+L
Show arguments	Ctrl+Alt+U

Designing transformations and jobs

The following are the shortcuts that help the design of transformations and jobs:

Action	Shortcut
New step/job entry	Drag the step/job entry icon to the work area and drop it there
Edit step/job entry	Double-click
Edit step description	Double-click the middle mouse button
New hop	Click a step and drag toward the second step while holding down the middle mouse button or while pressing Shift and holding down the left mouse button
Edit a hop	Double-click in transformations, right-click in jobs
Split a hop	Drag a step over the hop until it gets wider
Select some steps/job entries	Ctrl+click
Select all steps	Ctrl+A
Clear selection	Esc
Copy selected steps/job entries to clipboard	Ctrl+C
Paste from clipboard to work area	Ctrl+V
Delete selected steps/job entries	Del
Align selected steps/job entries to top	Ctrl+Up
Align selected steps/job entries to bottom	Ctrl+Down
Align selected steps/job entries to left	Ctrl+Left
Align selected steps/job entries to right	Ctrl+Right
Distribute selected steps/job entries horizontally	Alt+Right
Distribute selected steps/job entries vertically	Alt+Up
Zoom in	Page up
Zoom out	Page down
Zoom 100%	Home
Snap to grid	Alt+Home
Undo	Ctrl+Z
Redo	Ctrl+Y
Show output stream (only available in transformations)	Position the mouse cursor over the step; then press Space bar

Grids

Action	Shortcut
Move a row up	Ctrl+Up
Move a row down	Ctrl+Down
Resize all columns to see the full values (header included)	F3
Resize all columns to see the full values (header excluded)	F4
Select all rows	Ctrl+A
Clear selection	Esc
Copy selected lines to clipboard	Ctrl+C
Paste from clipboard to grid	Ctrl+V
Cut selected lines	Ctrl+X
Delete selected lines	Del
Keep only selected lines	Ctrl+K
Undo	Ctrl+Z
Redo	Ctrl+Y

Repositories

Action	Shortcut
Connect to repository	Ctrl+R
Disconnect repository	Ctr+D
Explore repository	Ctrl+E
Edit current user	Ctrl+U