Gaio DataOS
Gaio DataOS
Gaio DataOS
  • 👋 Welcome to Gaio DataOS
  • GETTING STARTED
    • Gaio DataOS Console
    • Quickstart
  • FUNDAMENTALS
    • Data Projects
    • Studio
    • Database
    • Workflow
  • Data Sources
  • TASKS
    • ETL
      • Builder
      • SQL
      • Source SQL
      • Insert Table
      • Insert Row
      • Update
      • Delete
      • Create Table
      • Quick Table
      • Quick Upload
      • Pivot Table
      • Unpivot Table
      • REST
      • Parameters to Table
      • Table to Parameters
      • Define parameter value
      • Users
      • CSV Web
      • CSV Local
      • Google Spreadsheet
    • Analytics
      • Sample
      • Cluster
      • Principal Components
      • Association Rules
      • Forecast
      • Python
    • Delivery
      • Content
      • Form Card
      • Export CSV
    • Map Editor
Powered by GitBook
On this page
  • How to Use
  • 1. Open the Pivot Table Task
  • 2. Set Task Name and Output Table
  • 3. Select Column to Pivot
  • 4. Configure Pivot Values
  • 5. Select Value to Aggregate
  • 6. Optional: Add Extra Columns
  • 7. Save and Run
  1. TASKS
  2. ETL

Pivot Table

PreviousQuick UploadNextUnpivot Table

Last updated 2 days ago

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.

How to Use

1. Open the Pivot Table Task

  • In the left-side menu, go to: Tasks > ETL > Pivot Table

2. Set Task Name and Output 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.

3. Select Column to Pivot

  • 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.

4. Configure Pivot Values

  • 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.

5. Select Value to Aggregate

  • 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.

6. Optional: Add Extra Columns

  • 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.

7. Save and Run

  • 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