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

Internal Name

ExpandKeystoColumns