This is a Laboratory tool and is not for production use. It may have documented known issues, may not be feature complete, and is subject to change.
The Make Columns tool takes rows of data and arranges them by wrapping records into multiple columns. The user can specify how many columns to create and whether they 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.
If the input contains 2 fields and 2 columns are specified (with no group specification), 4 columns will come out of the tool.
If the input contains 2 fields and 2 columns are specified along with one group field, 3 columns will come out of the tool.
Arrange Horizontally: Records are ordered by their incoming position and cells will be populated left to right until the specified amount of columns runs out, then they will wrap to the next row and continue left to right.
Arrange Vertically: Records are ordered by their incoming position and cells will be populated top to bottom in rows and will wrap to the specified amount of columns.
If there is not an exact match of records, [Null] values fill out the set.
Input data stream
Food |
---|
Apple |
Banana |
Cherry |
Date |
Asparagus |
Broccoli |
Carrot |
Daikon |
Arrange Horizontally
Column_1_Food | Column_2_Food |
---|---|
Apple | Banana |
Cherry | Date |
Asparagus | Broccoli |
Carrot | Daikon |
Arrange Vertically
Column_1_Food | Column_2_Food |
---|---|
Apple |
Asparagus |
Banana |
Broccoli |
Cherry |
Carrot |
Date |
Daikon |
Input data stream
Group | Food |
---|---|
Fruit | Apple |
Fruit | Cherry |
Fruit | Banana |
Fruit | Date |
Vegetable | Asparagus |
Vegetable | Carrot |
Vegetable | Broccoli |
Vegetable | Daikon |
Arrange Horizontally
Group | Column_1_Food | Column_2_Food |
---|---|---|
Fruit | Apple | Banana |
Fruit | Cherry | Date |
Vegetable | Asparagus | Broccoli |
Vegetable | Carrot | Daikon |
Arrange Vertically
Group | Column_1_Food | Column_2_Food |
---|---|---|
Fruit | Apple | Cherry |
Fruit | Banana | Date |
Vegetable | Asparagus | Carrot |
Vegetable | Broccoli | Daikon |
©2018 Alteryx, Inc., all rights reserved. Allocate®, Alteryx®, Guzzler®, and Solocast® are registered trademarks of Alteryx, Inc.