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.