transpose2

[ 1 Operator usage in easy mode ] [ 2 Usage details ] [ 3 Example ]

The transpose2 operator is a partition column that acts on multiple columns from the parent table. It is different from the transpose operator that has the time and prefix column.

Operator usage in easy mode

Click + on the parent node.
Enter the Transpose operator in the search field and select the operator from the Results to open the operator form.
In the Table drop-down, enter or select the table containing the data to run this operator on.
In the Group by Rows Columns drop-down, enter or select single or multiple column names to perform group by before transpose.
In the New Header Column drop-down, select a field name whose values will be the new column header.
In the Value Column field, select a column name whose values will be new values of cells.
Optional. In the New Column Prefix drop-down, prefix string to newHeaderColumn name in the output column. Click Add More to add additional columns with prefixes.
Click Run to view the result.
Click Save to add the operator to the playbook.
Click Cancel to discard the operator form.

Usage details

LQL

transpose(table:InputTable, groupbyrowscolumns:String, newheadercolumn:String, valuecolumn:String)

Parameters
table: input table that contains the information to create JSON object.
groupbyrowscolumns: column names to perform group by before transpose.
newheadercolumn: field name whose values will be new column names.
valuecolumn: column name whose values will be new values of cells.

Example

In the input table, enter the partition attributes.

The input table displays the following partitioned table.

col	time	val

col	time	val
one	1	1
one	2	21
two	1	2

When you apply the transpose2 operator, the output is shown as follows:

Text

transpose2(InputTable, ["time"], "col", "val", "new_col_prefix_")

The output table displays the following partitioned table.

time	new_col_prefix_one	new_col_prefix_two

time	new_col_prefix_one	new_col_prefix_two
1	1	2
2	21	null