Class QueryPivotRequest

Represents a pivot request. Transforms long format to wide format by spreading values into columns.

public class QueryPivotRequest

Properties

Gets or sets the aggregation type. Supported values: sum (default), mean, min, max, count, stddev, variance

public string AggregationType { get; set; }

Gets or sets the format string for generated column names. Use {pivot} for pivot value and {value} for value column name. Default: "{pivot}_{value}"

public string ColumnNameFormat { get; set; }

Gets or sets the column names to use as row identifiers. These columns become the row keys in the output.

public string[]? IndexColumns { get; set; }

Gets or sets the column whose unique values become new column names.

public string PivotColumn { get; set; }

Gets or sets the column containing values to aggregate.

public string ValueColumn { get; set; }