Extracting Metadata from the Input File

Metadata is data describing the data structure.

You can extract metadata from your flat data file or create it by your own. We will show you, how to extract it from input file.

Right-click the first edge and select New metadataExtract from flat file.

Extracting Metadata

Figure 1.15. Extracting Metadata


A wizard for metadata extraction opens. Use Browse button to open dialog to specify a file.

Introductory Window of Metadata Editor

Figure 1.16. Introductory Window of Metadata Editor


Select the input.dat file in data-in directory and click the OK button.

Selecting Data File

Figure 1.17. Selecting Data File


The Metadata Editor fills up:

Metadata Editor (Introductory Pane Filled)

Figure 1.18. Metadata Editor (Introductory Pane Filled)


Click Next to specify metadata fields.

Metadata Editor (Editing Pane)

Figure 1.19. Metadata Editor (Editing Pane)


As you can see, the wizard guessed that the records consisted of three fields and it also understood that the third field values were integer numbers.

You can replace the three default field names (Field1, Field2 and Field3) with more descriptive ones: FirstName, LastName and Salary.

To do that, click the Field1 item and enter the new field name.

Renaming a Field

Figure 1.20. Renaming a Field


Do the same with the other two field names. The result will look like this:

All Fields Have Been Renamed

Figure 1.21. All Fields Have Been Renamed


Now click Finish. This way you have created metadata. The metadata has been assigned to the edge.

[Note]Note

You can extract metadata on edges and on input components.