IEtlPlainRecordSet.Item

Syntax

Item(Index: Integer): IEtlPlainRecord;

Parameters

Index - flat record index.

Description

The Item property returns the object that contains the flat record, which index 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 unit macro that is used to transform data in ETL task. After executing the ETL task the first data consumer record corresponds to the last data source record, the second data consumer record to the next to last data source record, and so on.