Last updated: Feb 11, 2025
The Transpose node swaps the data in rows and columns so that
records become fields and fields become records.
Example
node = stream.create("transpose", "My node") node.setPropertyValue("transposed_names", "Read") node.setPropertyValue("read_from_field", "TimeLabel") node.setPropertyValue("max_num_fields", "1000") node.setPropertyValue("id_field_name", "ID")
properties |
Data type | Property description |
---|---|---|
|
enum | Specifies the transpose method: Normal ( ), CASE to VAR
( ), or VAR to CASE ( ). |
|
|
Property for the Normal transpose method. New field names can be generated automatically based on a specified prefix, or they can be read from an existing field in the data. |
|
string | Property for the Normal transpose method. |
|
integer | Property for the Normal transpose method. When using a prefix, specifies the maximum number of new fields to create. |
|
field | Property for the Normal transpose method. Field from which names are read. This must be an instantiated field or an error will occur when the node is executed. |
|
integer | Property for the Normal transpose method. When reading names from a field, specifies an upper limit to avoid creating an inordinately large number of fields. |
|
|
Property for the Normal transpose method. By default, only continuous (numeric range) fields are transposed, but you can choose a custom subset of numeric fields or transpose all string fields instead. |
|
list | Property for the Normal transpose method. Specifies the fields to transpose when the
option is used. |
|
field | Property for the Normal transpose method. |
|
field | Property for the CASE to VAR ( ) transpose method. Accepts multiple
fields to be used as index fields.
|
|
field | Property for the CASE to VAR ( ) transpose method. Accepts multiple
fields to be used as column fields.
|
|
field | Property for the CASE to VAR ( ) transpose method. Accepts multiple
fields to be used as value fields.
|
|
field | Property for the VAR to CASE ( ) transpose method. Accepts multiple
fields to be used as ID variable fields.
|
|
field | Property for the VAR to CASE ( ) transpose method. Accepts multiple
fields to be used as value variable fields.
|
|
array | New field names. |
|
|
When there's more than one record for an index, you must aggregate the records into one. Use the Aggregate Function drop-down to specify how to aggregate the records using one of the aggregation functions. |
|
|
Set the default mode for all fields to |
Was the topic helpful?
0/1000