Class PivotField
The type representing the pivot field. Pivot fields have an expression to define a macro and a pattern to generate the column name
Assembly: OCI.DotNetSDK.Dataintegration.dll
Syntax
public class PivotField : TypedObject
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
Declaration
[JsonProperty(PropertyName = "type")]
public BaseType Type { get; set; }
Property Value
UseType
Declaration
[JsonProperty(PropertyName = "useType")]
public ConfiguredType UseType { get; set; }
Property Value