Transpose columns to rows processor

Edited

The Transpose columns to rows processor transforms labels into field values.

For example, if a dataset—that contains the estimated number of inhabitants in France, the UK and the US, between 2020 and 2050—initially looks like it does in the table below, it can be difficult to analyze and use to produced visualizations, simply due to the format.

Country name

2020

2030

2050

France

70 000 000

80 000 000

100 000 000

UK

65 000 000

70 000 000

90 000 000

USA

350 000 000

400 000 000

450 000 000

But with the way the data is arranged below, it is possible to set up relevant filters and analyze the data. This processor allows you to make this change by creating a new field with the former field titles (Year), and another new field with the values left (Inhabitants).

Country Name

Year

Inhabitants

France

2020

70 000 000

UK

2020

65 000 000

USA

2020

350 000 000

France

2030

80 000 000

UK

2030

70 000 000

USA

2030

400 000 000

France

2050

100 000 000

UK

2050

90 000 000

USA

2050

450 000 000

Setting the processor

To set the parameters of the Transpose columns to rows processor, follow the indications from the table below.

Label

Description

Mandatory

Fixed fields

List of fields that will be kept as is

Yes

Invert fixed fields

If selected, the fields chosen in the Fixed fields parameter will be transposed instead of being kept as they are, and the other fields will, however, be treated as fixed fields

No

Label for title column

The name of the newly created field, containing the former fields titles

Yes

Label for value column

The name of the newly created field, containing the former records values

Yes

One line

If selected, these records values will not be split in several lines for each possible value, but separated by a defined separator

No

Separator

To fill if "One line" is set. Specifies the character to use to separate values in the new field

No