 |
 | Create the customers metadata
|
In the Repository on the left of the Talend Open Studio main screen: Expand the Metadata node. Right-click on File delimited. In the menu, click Create file delimited to open the New Delimited File wizard.
|
 |
In the New Delimited File wizard: In the Name field, name the metadata customers. Click Next to continue. |
 |
Click Browse... and select the customer.csv file from the wizard. From the Format list, select your computer OS. Click Next.
|
 |
In the Rows To Skip area, check the Header box and fill in the number of rows to ignore: 5. In the Preview area at the bottom of the wizard, check the Set heading row as column names box to retrieve the file column names.
Click Refresh Preview to update the structure and data preview. Click Next.
 | When you check the Set heading row as column names box, the number you entered in the Header field is incremented.
|
|
 |
In the Description of the Schema table, set the columns as shown in the screenshot. Sum1 and Sum2 columns are set the same way.
Click Finish to close the wizard.
|
 |
In the Repository on the left: The customers metadata is displayed in the Metadata > File delimited node.
|
| | |
|
The customers metadata is created. Now, create the states metadata.
Next
|
 |
| | |
 |
 | Create the states metadata
|
In the Repository on the left of the Talend Open Studio main screen: Expand the Metadata node. Right-click on File delimited. In the menu, click Create file delimited to open the New Delimited File wizard. |
 |
In the New Delimited File wizard: In the Name field, name the metadata states. Click Next to continue. |
 |
Click Browse... and select the state.txt file from the wizard. From the Format list, select your computer OS. Click Next. |
 |
In the Preview area at the bottom of the wizard, check the Set heading row as column names box to retrieve the file column names. Click Refresh Preview to update the structure and data preview. Click Next.
|
| When you check the Set heading row as column names box, the Header field is incremented.
|
|
 |
In the Description of the Schema table, set the columns as shown in the screenshot. Click Finish to close the wizard. |
 |
In the Repository on the left: The states metadata is displayed in the Metadata > File delimited node. |
| | |
|
The two metadata now exist, and can be used in a Job.
|
|
| | |
