Transpose
Transpose Function
Transpose function transposes a table. It needs to be specify maximum number of columns in the output as well as if the first column must be used as header.
Syntax
Transpose (table Table,scalar Value,scalar UseFirstColumnAsHeader)
Arguments
| Argument | Description |
|---|---|
table Table | Table |
scalar Value | Maximum number of column to be display |
scalar UseFirstColumnAsHeader | ♣ true- if the first column must be treated as the column names for the transposed table ♣ false- Automatic column name generation |
Examples:
Transpose([[FusionTestTable]],15 ,true)
Transposes FusionTestTable using first column as header and maximum number of rows is 15.