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.