Cutting and pasting schema information
This technique is a real time saver, but isn’t always immediately obvious, because the schema dialogue does not contain a right-click option.
Getting ready
Make a copy of the job jo_cook_ch02_0020_builtInSchema, rename it to jo_cook_ch02_0030_copySchema, and open the new job.
How to do it…
- Drag a
tFileOutputExcelcomponent from the right-hand palette. - Open
tFileOutputDelimited, and then open the schema. - Click the left-hand panel and press Ctrl+A to select all the columns.
- Press Ctrl+C to copy the highlighted columns.
- Open the
tFileOutputExcelcomponent, and then open the schema. It should be blank. - Press CTRL+V to paste the columns.
How it works…
Talend allows the standard windows shortcut keys to be used to cut and paste column information between schemas.
There’s more…
You can also use Ctrl+left mouse button to highlight individual columns and Shift+left mouse button to highlight a range as per the usual Windows conventions...
