Skip to main content Skip to complementary content

Preparing directors file metadata

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.

Before you begin

  • You have the file directors.txt ready in the directory C:\getting_started\input_data\.

Procedure

  1. 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.
  2. Enter a name for the file connection, directors in this example, and other useful information to better describe your file metadata, and then click Next to go to the next step and define the general properties of the file.
  3. In the File field specify the path of the source file, or click Browse to browse to the file.

    The file is loaded, and the File Viewer area displays an abstract of the file, allowing you to check the file consistency, the presence of header and more generally the file structure.

  4. Select Windows from the Format list, and click Next to parse the file.
  5. From the Field Separator list of the File Settings area, select Comma.
  6. Click Next to retrieve the file schema.

    The Description of the Schema table displays the generated file schema.

  7. 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.
  8. Click Finish to validate the schema close the wizard.

    The created file metadata is shown in the Repository tree view.

Results

You now have the directors file metadata ready for use when you set up the component to read the reference file.

Did this page help you?

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