transpose2
- Jonas Gonzalez
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 |
|---|---|---|
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 |
|---|---|---|
1 | 1 | 2 |
2 | 21 | null |