Reading the input data

Procedure

Double-click the tFileInputDelimited component to open its Component view.
Click the [...] button next to the File Name/Stream field to browse to the file that you want to read data from. In this scenario, the directory is D:/Input/Employees.csv. The CSV file contains four columns: id, age, name and ManagerID.id;age;name;ManagerID 1;20;Alex;1 2;40;Peter;1 3;25;Mark;1 4;26;Michael;1 5;30;Christophe;2 6;26;Stephane;3 7;37;Cedric;3 8;52;Bill;4 9;43;Jack;2 10;28;Andrews;4
In the Header field, enter 1 so that the first row in the CSV file will be skipped.
Click Edit schema to define the data to pass on to the tCassandraOutput component.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!