Class MacroPivotField

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

Inheritance

object

MacroPivotField

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.DataintegrationService.Models

Assembly: OCI.DotNetSDK.Dataintegration.dll

Syntax

public class MacroPivotField

Properties

ColumnNamePattern

Declaration

[JsonProperty(PropertyName = "columnNamePattern")]
public string ColumnNamePattern { get; set; }

Property Value

Type	Description
string	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.

Expr

Declaration

[JsonProperty(PropertyName = "expr")]
public Expression Expr { get; set; }

Property Value

Type	Description
Expression

IsUseSourceType

Declaration

[JsonProperty(PropertyName = "isUseSourceType")]
public bool? IsUseSourceType { get; set; }

Property Value

Type	Description
bool?	Specifies whether the type of macro fields is inferred from an expression or useType (false) or the source field (true).

Type

Declaration

[JsonProperty(PropertyName = "type")]
public BaseType Type { get; set; }

Property Value

Type	Description
BaseType

UseType

Declaration

[JsonProperty(PropertyName = "useType")]
public ConfiguredType UseType { get; set; }

Property Value

Type	Description
ConfiguredType