Make Columns Tool
Make Columns Tool
Laboratory Tool
This is a Laboratory tool and isn't for use in production. It might have documented known issues, might not be feature complete, and is subject to change.
Use Make Columns to take rows of data and arrange them by wrapping records into multiple columns. You can specify how many columns to create and whether you want records to layout horizontally or vertically.
This tool is useful for reporting or display purposes where you want to layout records to fit nicely within a table. Instead of showing a list of 50 records, you may want to wrap those records into a table of 5 columns and 10 rows, for example.
Configure the Tool
Number of columns: Specify the number of columns to create. For each existing field, a new column is created with a "Column_#" pre-pended to the column name.
If the input contains 2 fields and you specify 2 columns (with no group specification), 4 columns come out of the tool.
If the input contains 2 fields and you specify 2 columns in addition to one group field, 3 columns come out of the tool.
Choose to arrange records horizontally or vertically:
Arrange Horizontally: Designer orders records by their incoming position and populates cells from left to right until it fills the user-specified number of columns. After that, Designer wraps records to the next row and continues arranging them from left to right.
Arrange Vertically: Designer orders records by their incoming position and populates cells from top to bottom in rows. Designer wraps to the specified number of columns. If there isn't an exact match of records, [Null] values fille the set.
Grouping Fields (Optional): When a group field is specified, records are sorted by the Group value and arranged according to their incoming record position across columns for the particular group.
Examples
Ungrouped
Food |
|---|
Apple |
Banana |
Cherry |
Date |
Asparagus |
Broccoli |
Carrot |
Daikon |
Column_1_Food | Column_2_Food |
|---|---|
Apple | Banana |
Cherry | Date |
Asparagus | Broccoli |
Carrot | Daikon |
Column_1_Food | Column_2_Food |
|---|---|
Apple | Asparagus |
Banana | Broccoli |
Cherry | Carrot |
Date | Daikon |
Grouped
Group | Food |
|---|---|
Fruit | Apple |
Fruit | Cherry |
Fruit | Banana |
Fruit | Date |
Vegetable | Asparagus |
Vegetable | Carrot |
Vegetable | Broccoli |
Vegetable | Daikon |
Group | Column_1_Food | Column_2_Food |
|---|---|---|
Fruit | Apple | Banana |
Fruit | Cherry | Date |
Vegetable | Asparagus | Broccoli |
Vegetable | Carrot | Daikon |
Group | Column_1_Food | Column_2_Food |
|---|---|---|
Fruit | Apple | Cherry |
Fruit | Banana | Date |
Vegetable | Asparagus | Carrot |
Vegetable | Broccoli | Daikon |