You are here: Tools > Tool Categories > Laboratory > Make Columns

Make Columns Tool

IMPORTANT! 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.

Configuration Properties

  1. Number of columns: Specify the number of columns to create. For each existing field, a new column will be created with an "Column_#" pre-pended to the column name.

  2.  Choose to Arrange Horizontally or Vertically:

  3. 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.

  4. Select Group fields. This setting is 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

Input Data

Make Columns Tool Configuration

Output

Food

Apple

Banana

Cherry

Date

Asparagus

Broccoli

Carrot

Daikon

Anise

Basil

Cilantro

Dill

 

 

 

Number of Columns: 2

Arrange Horizontally

No Group field

 

Column_1_Food

Column_2_Food

Apple

Banana

Cherry

Date

Asparagus

Broccoli

Carrot

Daikon

Anise

Basil

Cilantro

Dill

     

Food

Apple

Banana

Cherry

Date

Asparagus

Broccoli

Carrot

Daikon

Anise

Basil

Cilantro

Dill

 
  

Number of Columns: 5

Arrange Horizontally

No Group field

 

Column_1_Food

Column_2_Food

Column_3_Food

Column_4_Food

Column_5_Food

Apple

Banana

Cherry

Date

Asparagus

Broccoli

Carrot

Daikon

Anise

Basil

Cilantro

Dill

[Null]

[Null]

[Null]

 

If there is not an exact multiple of records, NULL records will pad out the set.

Food

Apple

Banana

Cherry

Date

Asparagus

Broccoli

Carrot

Daikon

Anise

Basil

Cilantro

Dill

 

 

 

 

Number of Columns: 2

Arrange Vertically

No Group field

 

Column_1_Food

Column_2_Food

Apple

Carrot

Banana

Daikon

Cherry

Anise

Date

Basil

Asparagus

Cilantro

Broccoli

Dill

 

Group

Food

Fruit

Apple

Fruit

Banana

Fruit

Cherry

Fruit

Date

Vegetable

Asparagus

Vegetable

Broccoli

Vegetable

Carrot

Vegetable

Daikon

Spice

Anise

Spice

Basil

Spice

Cilantro

Spice

Dill

 
  

Number of Columns: 2

Arrange Horizontally

Group field: Group

 

Group

Column_1_Food

Column_2_Food

Fruit

Apple

Banana

Fruit

Cherry

Date

Spice

Anise

Basil

Spice

Cilantro

Dill

Vegetable

Asparagus

Broccoli

Vegetable

Carrot

Daikon

     

Group

Food

Fruit

Apple

Fruit

Banana

Fruit

Cherry

Fruit

Date

Vegetable

Asparagus

Vegetable

Broccoli

Vegetable

Carrot

Vegetable

Daikon

Spice

Anise

Spice

Basil

Spice

Cilantro

Spice

Dill

 
  

Number of Columns: 2

Arrange Vertically

Group field: Group

 

Group

Column_1_Food

Column_2_Food

Fruit

Apple

Cherry

Fruit

Banana

Date

Spice

Anise

Cilantro

Spice

Basil

Dill

Vegetable

Asparagus

Carrot

Vegetable

Broccoli

Daikon