Configuring the source file

Procedure

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.

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