MacroPivotField

class oci.data_integration.models.MacroPivotField(**kwargs)

Bases: object

MacroPivotField is used for the PivotField with macro expressions. It can contain the rules according to the macro pattern/attribute added and create new fields according to the PivotKeyValues

Methods:

__init__(**kwargs)

Initializes a new MacroPivotField object with values from keyword arguments.

Attributes:

column_name_pattern

Gets the column_name_pattern of this MacroPivotField.

expr

Gets the expr of this MacroPivotField.

is_use_source_type

Gets the is_use_source_type of this MacroPivotField.

type

Gets the type of this MacroPivotField.

use_type

Gets the use_type of this MacroPivotField.

__init__(**kwargs)

Initializes a new MacroPivotField object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters
  • is_use_source_type (bool) – The value to assign to the is_use_source_type property of this MacroPivotField.

  • expr (oci.data_integration.models.Expression) – The value to assign to the expr property of this MacroPivotField.

  • use_type (oci.data_integration.models.ConfiguredType) – The value to assign to the use_type property of this MacroPivotField.

  • type (oci.data_integration.models.BaseType) – The value to assign to the type property of this MacroPivotField.

  • column_name_pattern (str) – The value to assign to the column_name_pattern property of this MacroPivotField.

property column_name_pattern

Gets the column_name_pattern of this MacroPivotField. column name pattern can be used to generate the name structure of the generated columns. By default column names are of %PIVOT_KEY_VALUE% or %MACRO_INPUT%_%PIVOT_KEY_VALUE%, but we can change it something by passing something like MY_PREFIX%PIVOT_KEY_VALUE%MY_SUFFIX or MY_PREFIX%MACRO_INPUT%_%PIVOT_KEY_VALUE%MY_SUFFIX which will add custom prefix and suffix to the column name.

Returns

The column_name_pattern of this MacroPivotField.

Return type

str

property expr

Gets the expr of this MacroPivotField.

Returns

The expr of this MacroPivotField.

Return type

oci.data_integration.models.Expression

property is_use_source_type

Gets the is_use_source_type of this MacroPivotField. Specifies whether the type of macro fields is inferred from an expression or useType (false) or the source field (true).

Returns

The is_use_source_type of this MacroPivotField.

Return type

bool

property type

Gets the type of this MacroPivotField.

Returns

The type of this MacroPivotField.

Return type

oci.data_integration.models.BaseType

property use_type

Gets the use_type of this MacroPivotField.

Returns

The use_type of this MacroPivotField.

Return type

oci.data_integration.models.ConfiguredType