IEtlPlainRecordSet.Fields

Syntax

Fields: IEtlPlainFields;

Description

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

Example

Sub UserSub(Input: IEtlPlainRecordSets; Output: IEtlPlainRecordSets);

Var

RecordSetIn, RecordSetOut: IEtlPlainRecordSet;

i: Integer;

Begin

RecordIn:=Input.Item(0);

RecordOut:=Output.Item(0);

For i := 0 To RecordIn.Fields.Count - 1 Do

RecordSetOut.Add;

RecordSetOut.Item(i).Value(0):=RecordSetIn.Fields.Item(i).Id;

End For;

End Sub UserSub;

This example is a custom unit macro that is used to transform data in ETL task. After executing the ETL task the first data consumer field contains identifiers of all data source fields.