IEtlPlainRecord.Count

Syntax

Count: Integer;

Description

The Count property returns the number of values (fields) of a flat record.

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.Count;

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 in the first field of the data consumer, all records contain number of data source fields.