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.

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

expr¶

Gets the expr of this MacroPivotField.

Returns:	The expr of this MacroPivotField.
Return type:	oci.data_integration.models.Expression

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

type¶

Gets the type of this MacroPivotField.

Returns:	The type of this MacroPivotField.
Return type:	oci.data_integration.models.BaseType

use_type¶

Gets the use_type of this MacroPivotField.

Returns:	The use_type of this MacroPivotField.
Return type:	oci.data_integration.models.ConfiguredType