When you define any of the three transformation attributes, specify a transformation that assigns a number of output port to each input record.

For detailed information about CloverDX Transformation Language, see Part X, CTL2 - CloverDX Transformation Language. (CTL is a full-fledged, yet simple language that allows you to perform almost any imaginable transformation.)

CTL scripting allows you to specify a custom transformation using the simple CTL scripting language.

Reformat uses the same transformation template as DataIntersection and Joiners. For more information, see CTL Templates for Joiners.

This example shows a way to use Reformat to drop unnecessary metadata fields.

Input metadata contains the firstname, surname and address fields. Output metadata contains the firstname and surname fields. Drop the address field.

//#CTL2
function integer transform() {
    $out.0.firstname = $in.0.firstname;
    $out.0.surname = $in.0.surname;

    return ALL;
}

This example shows a way to use Reformat to split one record to multiple parts and send each part to a different output port.

Input metadata contains the ID, firstname, surname and address fields. Send ID, firstname and surname to the first output port and ID and address to the second output port.

//#CTL2
function integer transform() {
    $out.0.ID = $in.0.ID;
    $out.0.firstname = $in.0.firstname;
	$out.0.surname = $in.0.surname;

    $out.1.ID = $in.0.ID;
    $out.1.address = $in.0.address;

    return ALL;
}

Reformat can be used as a filter.

Input metadata contains the ID and color fields. Valid colors are red, green, or blue. Send red items to the first output port; green items to the second output port; and blue items to the third output port. Items without correct color should be send to the fourth output port.

//#CTL2
function integer transform() {
    if ( $in.0.color == "red" ) {
        $out.0.* = $in.0.*;
        return 0;
    }
    if ( $in.0.color == "green" ) {
        $out.1.* = $in.0.*;
        return 1;
    }
    if ( $in.0.color == "blue") {
        $out.2.* = $in.0.*;
        return 2;
    }

    $out.3.* = $in.0.*;
    return 3;
}

There are components specialized on filtering of records: Filter and Validator.