How to create metadata from CSV file

In this post will see how to use the metadata repository section to make the components reusable.
It will help us to develop the job faster.

Let's go through an example of metadata configuration for CSV file.
Here is Student Input CSV file.

student_id;student_name;student_branchid
101;RK Sharma;1
102;Aditya Tiwari;2
103;Gaurav Tiwari;3
104;Shashi Singh;4
105;Yogesh Mishra;5
106;Ankit Gupta;8

Now follow the steps given below:-

Step1:- Open Talend Open studio your project Talend_Tutorials and right click "File Delimited" under the "Metadata" section in the Repository panel. Click Create file delimited.

Step 2:- In the next window, enter the name of metadata. You can also enter additional information in the Purpose and Description boxes. There are other configuration options for Version, Status, and Path, but these are not mandatory, so we will leave them for now. Click on next button. 

Step 3:-Provide the path where you have created your CSV input file and click next. You can also see the contents of the File in the File Viewer section. 

Step 4:- Select Encoding to UTF-8. Also provide the Field Separator and Row separator characters. You can also select the Header and Footer rows to be skipped in Rows To Skip section and click refresh preview button.
   

Step 5:- Enter the name of the schema and you can also update the data type, null ability and length as per requirements and click on Finish.

Step 6:- You can see the metadata in the Repository panel, under the Metadata Section.