Working with grids

Grids are tables used in many instances in Spoon to enter or display information. You have already edited grids in the configuration window of the Data Grid and the UDJE steps.

Grids can be used for entering different kinds of data. No matter what kind of grid you are editing, there is always a contextual menu that you may access by right-clicking on a row. That menu offers editing options such as copying, pasting, or moving rows of the grid.

When the number of rows in the grid is high, use shortcuts! Most of the editing options of a grid have shortcuts that make editing easier and quicker.

The following is a full list of shortcuts for editing grids. The value between brackets is the option for Mac users:

Grids are usually accompanied by a Get Fields button. The Get Fields button is a facility to avoid typing. When you press that button, PDI fills the grid with all the available fields.

Every time you see a Get Fields button, consider it as a shortcut to avoid typing. PDI will bring the fields available to the grid, and you will only have to check the information brought and do minimal changes.