 |
 | Set the processing component parameters
|
In the Palette on the right: Click the Processing family to add the processing component. Click the tMap component and drop it on the Job Designer between the Customers and the tLogRow components.
|
 |
In the Job Designer: Click on the row1 link and move its starting point from the Customers component to the tMap. To link the Customers to the tMap, right-click on Customers, hold, and drag to the tMap.
|
 |
In the Job Designer: Double-click on the tMap to open the tMap editor. In the tMap editor: Click Auto map! on the toolbar at the top of the editor to map the columns for the input schema to the columns of the output schema. Click the row2.lastname column in the row1 table and click [...] to open the Expression Builder.
|
 |
In the Expression Builder: You can change the last names of the customers to uppercase.
Select row2.lastname and cut it via Ctrl+X in the Expression area. In the Category list, click StringHandling and in the Functions list, double-click UPCASE.
StringHandling.UPCASE("Hello") will display in the Expression area. Paste your selection between the brackets instead of "Hello" to obtain StringHandling.UPCASE(row2.lastname). Click OK.
|
 |
In the tMap editor: Click the row2.id column. Click the Expression editor tab at the bottom of the editor. Type row2.id * 5 to multiply each id by five. Click OK.
|
 |
 | Run the Job
|
In the Job Designer: Press Ctrl+S to save the Job. Press F6 to run it. The Run view displays at the bottom of Talend Open Studio and the console follows the Job execution.
|
| | |
|
The Job is working! Its reads a delimited file, transforms its data, and displays the result in the console. Now we will add another input, join the two inputs and map them in a database.
|
 |
| | |
