Click the Guess Query button to fill the
Query field with the SQL query statement to
be executed on the specified table. In this example, it is as follows:
In the Field to split list, select the
delimited string column to be extracted. In this example, it is DelimitedField.
In the Field separator, enter the separator
used to separate the fields in the delimited string column. In this example, it
Click the [...] button next to Edit schema and in the pop-up window define the
schema by adding five columns: Id of Integer
type, and Name, Age, Team, Title of String type.
In this example, the delimited string column DelimitedField is split into three columns Age, Team and
Title, and the Id and Name columns are kept
Click OK to close the schema editor and
accept the propagation prompted by the pop-up dialog box.
Double-click the second tLogRow to open its
Basic settings view.
In the Mode area, select Table (print values in cells of a table) for better
readability of the result.