Expand Keys to Columns
Description
Create a table containing a data column for each key found in a given input table.
Inputs
| Name | Type | Description |
|---|---|---|
| Input tables | Table | This table must have exactly two key columns and any number of data columns. The user can choose which data column will be used to generate the output table. |
| Key column name | Name | The name of the key column in the output table. |
| Data column name prefix | Name | The prefix used to name the data columns in the output table. |
| Original data column | Index Or Name Type | The index or name of data column used to generate the output table. The default value corresponds to the first data column. |
Optional Inputs
None.
Outputs
| Name | Type | Description |
|---|---|---|
| Output table | Table | The resulting output table. |
Notes
- The input table must have exactly two key columns and any number of data columns.
- The user can choose which data column will be used to generate the output table.
- The resulting table has a key column and N data columns, where N is the number of unique leys found in the first key column of the input table.
Group
Internal Name
ExpandKeystoColumns