====== Expand Keys to Columns ====== 

===== Description =====

{{:submodels:submodel16.png?nolink|Submodel}} Create a table containing a data column for each key found in a given input table. 

===== Inputs =====

^ Name  ^ Type  ^ Description  ^
| Input tables  | [[table_type|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_type|Name]]  | The name of the key column in the output table.   |
| Data column name prefix  | [[name_type|Name]]  | The prefix used to name the data columns in the output table.   |
| Original data column  | [[index_or_name_type|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_type|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 =====

[[Functor List#Table | Table]]

===== Internal Name ===== 

ExpandKeystoColumns