Variables to Table
The handler transforms the list of variables to table. It is possible to place the values of variables in the strings or columns of the resulting table.
Ports
Input
Input variables: list of variables to be transformed to a table.
Output
Output data set: data table.
Wizard
Two options of variables record are specified in the wizard:
- to columns: each variable will correspond to a separate table field.
- to strings: each variable will correspond to a separate table record.
Example:
There is a list of variables:
| Name | Value |
|---|---|
| a | 5 |
| b | 7 |
| c | 10 |
| d | 2 |
Result of the variables list transformation:
- To columns
| a(sum) | b(sum) | c(sum) | d(sum) |
|---|---|---|---|
| 5 | 7 | 10 | 2 |
- To strings
| Name | Caption | Value |
|---|---|---|
| a | a(sum) | 5 |
| b | b(sum) | 7 |
| c | c(sum) | 10 |
| d | d(sum) | 2 |