> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# AggregateUnpivotRequest

> AggregateUnpivotRequest — Kinetica TypeScript API

interface AggregateUnpivotRequest \{\
&#x20;[column\_names](#column_names): string\[];\
&#x20;[encoding](#encoding)?: string;\
&#x20;[options](#options)?: Record\<string, string>;\
&#x20;[pivoted\_columns](#pivoted_columns): string\[];\
&#x20;[table\_name](#table_name): string;\
&#x20;[value\_column\_name](#value_column_name)?: string;\
&#x20;[variable\_column\_name](#variable_column_name)?: string;\
}

<ul>
  <li>Defined in [src/types.ts:749](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L749)</li>
</ul>

##### Index

### Properties

[column\_names](#column_names) [encoding?](#encoding) [options?](#options) [pivoted\_columns](#pivoted_columns) [table\_name](#table_name) [value\_column\_name?](#value_column_name) [variable\_column\_name?](#variable_column_name)&#x20;

## Properties

### column\_names

column\_names: string\[]

List of column names or expressions. A wildcard '\*' can be used to include all the non-pivoted columns from the source table.

<ul>
  <li>Defined in [src/types.ts:753](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L753)</li>
</ul>

### `Optional`encoding

encoding?: string

Specifies the encoding for returned records.

<ul>
  <li>Defined in [src/types.ts:761](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L761)</li>
</ul>

### `Optional`options

options?: Record\<string, string>

Optional parameters.

<ul>
  <li>Defined in [src/types.ts:763](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L763)</li>
</ul>

### pivoted\_columns

pivoted\_columns: string\[]

List of one or more values typically the column names of the input table. All the columns in the source table must have the same data type.

<ul>
  <li>Defined in [src/types.ts:759](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L759)</li>
</ul>

### table\_name

table\_name: string

Name of the table on which the operation will be performed. Must be an existing table/view, in \[schema\_name.]table\_name format, using standard name resolution rules.

<ul>
  <li>Defined in [src/types.ts:751](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L751)</li>
</ul>

### `Optional`value\_column\_name

value\_column\_name?: string

Specifies the value column name.

<ul>
  <li>Defined in [src/types.ts:757](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L757)</li>
</ul>

### `Optional`variable\_column\_name

variable\_column\_name?: string

Specifies the variable/parameter column name.

<ul>
  <li>Defined in [src/types.ts:755](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L755)</li>
</ul>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.