Fold multiple columns
Perform the opposite of a pivot and fold a list of columns , transforming a wide dataset into a narrow one. This is also sometimes called a melt. This processor outputs two columns: one containing column names and the other containing column values .
Example
student |
math |
science |
arts |
---|---|---|---|
Marie |
85 |
83 |
81 |
Caroline |
74 |
91 |
86 |
Paul |
70 |
85 |
89 |
Applying “Fold multiple columns” with
class
for folded column names and
grade
for folded values generates the following table:
student |
class |
grade |
---|---|---|
Marie |
math |
85 |
Marie |
science |
83 |
Marie |
arts |
81 |
Caroline |
math |
74 |
Caroline |
science |
91 |
Caroline |
arts |
86 |
Paul |
math |
70 |
Paul |
science |
85 |
Paul |
arts |
89 |
Options
Column for folded column names
Column containing the names of folded columns.
Column for folded values
Column containing the values of folded columns.
Remove folded columns
Remove the now empty folded columns.