IEtlPlainRecordSet.Count

Syntax

Count: Integer;

Description

The Count property returns number of records in flat data set.

Example

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

Var

RecordSetIn, RecordSetOut: 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.Count;

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