Hitachi Vantara Pentaho Community Wiki
Child pages
  • .15 Grids
Skip to end of metadata
Go to start of metadata

Grids

Description

Grids (tables) are used throughout the Spoon interface to enter or display information. This section describes common functions available when working with a Grid.

Usage

Click on a cell to begin editing that field. After pressing enter, you can navigate the grid by using the cursor keys. Pressing enter again allows you to edit the newly selected field.

The following table describes the functions available when you right- click on a cell in the grid:

Option

Description

Insert before this row

Inserts an empty row before the row you clicked on.

Insert after this row

Inserts an empty row after the row you clicked on.

Move the row up

Move the row you clicked on up. The keyboard shortcut for this is CTRL-UP

Move the row down

Move the row you clicked on down. The keyboard shortcut for this is CTRL-DOWN.

Optimal column size including header

Resize all columns so that it displays all values completely, including the header. The keyboard shortcut for this function is function key F3.

Optimal column size excluding header

Resize all columns so that it displays all values completely. The keyboard shortcut for this function is function key F4.

Clear all

Clears all information in the grid. You will be asked to confirm this operation.

Select all rows

Selects all rows in the grid. The keyboard shortcut for this function is CTRL-A.

Clear selections

Clears the selection of rows in the grid. The keyboard shortcut for this function is ESC.

Copy selected lines to clipboard

Copies the selected lines to the clipboard in a textual representation. These lines can then be exchanged with other programs such as spreadsheets or even other Spoon & Kettle dialogs. The keyboard shortcut for this function is CTRL-C.

Past clipboard to table

Insert the lines that are on the clipboard to the grid, right after the line on which you clicked. The keyboard shortcut for this function is CTRL-V.

Cut selected lines

Copies the selected lines to the clipboard in a textual representation. After that, the lines are deleted from the grid. The keyboard shortcut for this function is CTRL-X.

Delete selected lines

Deletes all selected lines from the grid. The keyboard shortcut for this function is DEL.

Keep only selected lines

If there are more lines to delete then there are to keep, simply select the lines you want to keep and use this function. They keyboard shortcut for this function is CTRL-K.

Copy field values to all rows

If all rows in the grid must have the same value for a certain column, you can use this function to do this.

Undo

Undo the previous grid operation. The keyboard shortcut for this function is CTRL-Z.

Redo

Redo the next grid operation. The keyboard shortcut for this function is CTRL-Y.