IEtlPlainRecordSet.Fields

Syntax

Description

The Fields property returns the object that contains flat data fields set.

Example

The example is a custom unit macro that is used to transform data in ETL task.

Add a link to the Etl system assembly.

Sub UserSub(Input: IEtlPlainRecordSets; Output: IEtlPlainRecordSets);
Var
    RecordSetIn, RecordSetOut: IEtlPlainRecordSet;
    i: Integer;
Begin
    RecordSetIn := Input.Item(0);
    RecordSetOut := Output.Item(0);
    For i := 0 To RecordSetIn.Fields.Count - 1 Do
        RecordSetOut.Add;
        RecordSetOut.Item(i).Value(0) := RecordSetIn.Fields.Item(i).Id;
    End For;
End Sub UserSub;

After executing the ETL task the first data consumer field contains identifiers of all data provider fields.