Getting a schema of a csv file in Talend

In Talend tool if you want to get the records from the CSV file. You want to configure its schema.

Let's see how to do that.

In the Repository pallet expand metadata --> File delimited --> (Right click) Create file delimited.

Give a file name --> click next --> select the file path --> click next.

Now is the interesting part. Configure the dialog box as shown below and then click refresh preview.

Click next, The dialog box will show the metadata of the file.

Select all the metadata and click on the copy icon(highlighted in the screen below) and click finish.

Now we got metadata you paste that in the desired place.

In order to configure a tFileOutputDelimited schema click on the ... icon in the component properties pallet and paste the schema.

Cheers!!! Have a great day... laugh

Rating: 
Average: 5 (1 vote)