Skip to content
On this page

Transformations

Transformations are a way to modify the data in your query. They are performed after the data is fetched from the database and before the data is displayed in the query result. You can add multiple transformations to your query.

You can perform the following transformations by clicking on the 3-dot menu beside the title of the query.

Transformations

Pivot

Pivot is used to transform the data from a row-based format to a column-based format.

Example:

IDcategorysales
1Consumables10
2Consumables20
3Hardware30

After pivoting the data on the category column, the data will look like this:

IDConsumablesHardware
110
220
330

Unpivot

Unpivot is used to transform the data from a column-based format to a row-based format.

Example:

IDConsumablesHardware
110
220
330

After unpivoting the data with new column name category and sales, the data will look like this:

IDCategorySales
1Consumables10
2Consumables20
3Hardware30

Released under the MIT License.