IEtlPlainRecordSet.Item

Syntax

Item(Index: Integer): IEtlPlainRecord;

Parameters

Index is the flat record index.

Description

The Item property returns an object that contains flat record index of which is passed by the Index parameter.

Example

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

Var

RecordIn, RecordOut: IEtlPlainRecordSet;

i: Integer;

Begin

RecordSetIn:=Input.Item(0);

RecordSetOut:=Output.Item(0);

For i := 0 To RecordSetIn.Count - 1 Do

RecordSetOut.Add;

RecordSetOut.Item(i).Value(0):=RecordSetIn.Item(RecordSetIn.Count - 1-i).Value(0);

End For;

End Sub UserSub;

This example is a custom module macro, used to transform data in ETL task. After executing the ETL task, the first consumer record corresponds to the last source record, the second consumer record - to the next to last source record and so on.