Version

    MetaPivot

    Short Description
    Ports
    Metadata
    MetaPivot Attributes
    Details
    Examples
    See also

    Short Description

    MetaPivot converts every incoming record into several output records, each one representing a single field from the input.

    ComponentSame input metadataSorted inputsInputsOutputsJavaCTLAuto-propagated metadata
    MetaPivot-
    no
    11
    no
    no
    yes

    Ports

    Port typeNumberRequiredDescriptionMetadata
    Input0
    yes
    For input data recordsAny1
    Output0
    yes
    For transformed data recordsAny2

    Metadata

    MetaPivot does not propagate metadata.

    MetaPivot has a metadata template on its output port.

    [Important]Important

    When working with MetaPivot, you have to use a fixed format of the output metadata. The metadata fields represent particular data types. Field names and data types have to be set exactly as follows (otherwise unexpected BadDataFormatException will occur):

    Field NameTypeDescription
    recordNolongThe serial number of a record (outputs can be later grouped by this) - fields of the same record share the same number.
    fieldNointegerThe current field number: 0...n-1 where n is the number of fields in the input metadata.
    fieldNamestringThe name of the field as it appears on the input
    fieldTypestringThe field type, e.g. string, date, decimal
    valueBooleanbooleanThe boolean value of the field.
    valueBytebytethe byte value of the field
    valueDatedatethe date value of the field
    valueDecimaldecimalthe decimal value of the field
    valueIntegerintegerthe integer value of the field
    valueLonglongthe long value of the field
    valueNumbernumberthe number value of the field
    valueStringstringthe string value of the field

    MetaPivot Attributes

    MetaPivot has no transformation-affecting attributes.

    Details

    On its single input port, MetaPivot receives data that does not have to be sorted. Each field of the input record is written as a new line on the output. The metadata represents data types and is restricted to a fixed format, see Details. All in all, MetaPivot can be used to effectively transform your records to a neat data-dependent structure.

    Unlike Normalizer, which MetaPivot is derived from, no transformation is defined. MetaPivot always does the same transformation: it takes the input records and rotates them from input columns to output rows.

    The total number of output records produced by MetaPivot equals to (number of input records) * (number of input fields).

    Some of the fields only make the output look better arranged. These can be omitted if required. The fields that do not have to be included in the output metadata are: recordNo, fieldNo and fieldType.

    Examples

    Converting Line to List

    Convert records with metadata fields username, surname and first name.

    doejohn|Doe  |John     
    smithel|Smith|Elisabeth
    ...

    into lines having each field value on a separate line:

    username |doejohn
    surname  |John
    firstname|Doe
    username |smithel
    surname  |Elisabeth
    firstname|Smith
    ...
    Solution

    Place the component into a graph and connect edges. The component does not need to be set up.

    Note: You need Reformat to exclude unnecessary output fields.