IEtlPlainFields.Clear

Syntax

Clear;

Description

The Clear method clears the list of input or output fields for an ETL task object.

Example

Sub Main;

Var

MB: IMetabase;

Object: IMetabaseObject;

EtlTask: IEtlTask;

Join: IEtlPlainDataJoin;

Input: IEtlPlainInput;

Fields: IEtlPlainFields;

Field: IEtlPlainField;

Begin

MB:=MetabaseClass.Active;

Object:=MB.ItemById("ETL").Edit;

EtlTask:=Object As IEtlTask;

Join:=EtlTask.Item(0) As IEtlPlainDataJoin;

Input:=Join.PlainInputs.Item(0);

Fields:=Input.Fields;

Fields.Clear;

Object.Save;

End Sub Main;

After executing the example fields list of the first input of the first ETL task object is cleared. The type of ETL task object is Join. The repository object has the ETL identifier.