IEtlPlainRecord.Value

Syntax

Value(Index: Integer): Variant;

Parameters

Index - index of flat record field.

Description

The Value property determines value of a flat record field, which index is passed by the Index parameter.

Example

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

Var

RecordSetIn, RecordSetOut: IEtlPlainRecordSet;

RecordIn, RecordOut: IEtlPlainRecord;

i: Integer;

Begin

RecordSetIn:=Input.Item(0);

RecordSetOut:=Output.Item(0);

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

RecordSetOut.Add;

RecordIn:=RecordSetIn.Item(i);

RecordOut:=RecordSetOut.Item(i);

RecordOut.Value(0):=RecordIn.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 field is put in correspondence with the first data source field.