This procedure shows how to set up the metadata of the reference file directors.txt in the Repository. This metadata item will be used to add and set up the lookup input in this scenario.
You have the file directors.txt ready in the directory C:\getting_started\input_data\.
In the Repository tree view, expand the Metadata node, right-click File delimited, and select Create file delimited from the contextual menu to open the [New Delimited File] wizard.
In the [New Delimited File] wizard enter a name for the file metadata, directors in this example, and other useful information to better describe your file metadata. Then, click Next to go to the next step and define the general properties of the file.
In the File field specify the path of the source file, C:/getting_started/input_data/directors.txt in this example, or click Browse to browse to the file.
The File Viewer area displays an abstract of the file, allowing you to check the file consistency, the presence of a header and the structure of the file.
Select Windows from the Format list, and click Next to parse the file.
From the Field Separator list of the File Settings area, select Comma.
Click Next to go to retrieve the file schema.
The Description of the Schema table displays the generated file schema.
Name the schema directors_schema and rename the columns to directorID and directorName respectively, and change the data type of the directorID columns from Integer to String.
Click Finish to close the wizard.
The created file metadata is shown in the Repository tree view.
You now have the directors file metadata ready for use when you set up the component to read the reference file.