Cutting and pasting schema information_Talend Open Studio Cookbook-QQ阅读仙侠女生网

上QQ阅读APP看书，第一时间看更新

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 tFileOutputExcel component 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 tFileOutputExcel component, 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.

Tip

Note that the pasted columns are added to the end of a schema, they do not replace existing columns. This means that in many cases further work will be needed to move the new columns to the correct place in the schema.