The Pivot Table task in Gaio DataOS allows you to reshape your dataset from a long format (rows) into a wide format (columns), turning categorical values into new columns. It’s ideal for creating cross-tab reports, category comparisons, and dashboard-ready summaries.
Important: This task can only be used when a table is selected in your flow.
In the left-side menu, go to: Tasks > ETL > Pivot Table
Task label: (optional) A name for this task within your flow.
Result table: The name of the new table to be created from the pivot transformation.
Column to pivot: Choose the column whose unique values will become new column headers (e.g., product_category).
Sort values: Choose the sorting order for the new columns: Ascending or Descending.
A list of unique values from the pivot column will appear.
You can rename each one under the Transpose column to customize the new headers.
Value to pivot: Choose the numeric column you want to summarize (e.g., sales_amount, units_sold).
Aggregation values: Select the aggregation method:
Sum
Average
Count, etc.
Extra columns: Select columns that should be preserved in the output (e.g., region, date).
Position of extra columns: Choose whether they appear At start or At end of the resulting table.
Save: Saves the task for later use in the flow.
Click Run to execute the task in your flow.
Use Cases
Compare product categories side by side
Summarize metrics by region, time, or status
Create custom pivot views for dashboards
Transform transactional data into report-ready formats
Last updated
