Transpose columns to rows processor
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 |