Expand Keys to Columns

Description

Submodel 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

Table

Internal Name

ExpandKeystoColumns