-
Drop a tFileInputDelimited and a tAdvancedFileOutputXML from the Palette onto the design workspace.
-
Alternatively, if you configured a description for the input delimited file in
the Metadata area of the Repository, then you can directly drag & drop the metadata
entry onto the editor, to set up automatically the input flow.
-
Right-click on the input component and drag a row main link towards the
tAdvancedFileOutputXML component to
implement a connection.
-
Select the tFileInputDelimited component and
display the Component settings tab located in
the tab system at the bottom of the Studio.
-
Select the Property type, according to
whether you stored the file description in the Repository or not. If you dragged
& dropped the component directly from the Metadata, no changes to the
setting should be needed.
If you didn't setup the file description in the Repository, then select Built-in and manually fill out the fields displayed on the
Basic settings vertical tab.
The input file contains the following type of columns separated by
semi-colons: id, name,
category, year,
language, director and
cast.
In this simple use case, the Cast field
gathers different values and the id increments when changing movie.
-
If needed, define the tFileDelimitedInput
schema according to the file structure.
-
Once you checked that the schema of the input file meets your expectation,
click on OK to validate.