IEtlPlainRecordSet.Fields

Syntax

Fields: IEtlPlainFields;

Description

The Fields property returns an 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 module macro, used to transform data in ETL task. After execution of the ETL task there are identifiers of all data source fields in the first consumer field.