Pivot Columns
Infoveave Data Automation — Pivot & Transpose
Row by row in. Cross-tab table out. No SQL, no spreadsheets, no waiting.
Most source systems export data in long format — one row per event, transaction, or measurement. Dashboards and reports need wide format — one row per entity with comparisons across columns. Pivot Columns bridges that gap inside your automated workflow, eliminating the pivot-table-in-Excel step that slows down every reporting cycle.
What Pivot Columns does
Convert long-format data into wide cross-tab tables inside your Infoveave workflow. No SQL, no Excel pivots — Pivot Columns reshapes data automatically on every scheduled run.
When to use Pivot Columns
- Your BI dashboard or charting tool expects data in wide format but your source exports it in long format
- You want to compare a metric (price, quantity, OEE) side-by-side across categories, departments, or time periods
- You are building automated cross-tab or matrix reports where the column structure changes based on the data
- You need to convert product-category-value triplets into a category row with one column per product
When to avoid it
- Your Labels Column has hundreds or thousands of unique values — each becomes a column, producing an unmanageably wide table
- You need to sum or average values before pivoting — run Aggregate Data by Column first, then Pivot
Where it fits in your Infoveave automation
Pivot Columns is one step inside a multi-step Infoveave workflow. Chain it with other activities — no code, no manual hand-offs.
Build this workflow visually in Infoveave Data Automation — drag, connect, and schedule with no infrastructure setup.
How teams use Pivot Columns
Real scenarios where this transformation saves hours of manual work.
Product Price Comparison Across Departments
A retail chain receives daily price feeds with one row per product per department. Pivot Columns converts this into one row per product with a column per department price — feeding directly into a competitive pricing dashboard without any spreadsheet manipulation.
OEE by Machine and Shift
Production data arrives with one row per machine-shift combination. Pivoting on shift converts this to one row per machine showing OEE across Morning, Afternoon, and Night shifts side-by-side — ready for the operations dashboard with no manual reformatting.
Budget vs Actual vs Forecast by Cost Centre
Financial exports arrive with budget type (Actual / Budget / Forecast) as a row value. Pivoting on budget type produces a clean cost-centre × Actual / Budget / Forecast table with automatic updates every period — eliminating the end-of-month manual reconciliation step.
See Pivot Columns in action
Input data (left) is transformed using the configuration below. The output table (right) is ready for dashboards or downstream steps.
categoryproductpriceInput Data
| ID | Category | Product | Price |
|---|---|---|---|
| 1 | Electronics | Laptop | 500 |
| 2 | Electronics | Camera | 350 |
| 3 | Furniture | Sofa | 600 |
| 4 | Furniture | Bed | 450 |
Output Data
| Category | Laptop | Camera | Sofa | Bed |
|---|---|---|---|---|
| Electronics | $500 | $350 | — | — |
| Furniture | — | — | $600 | $450 |
Configuration
Key fields to configure in the Infoveave workflow builder. Full reference available in the documentation.
Index Column
Defines the output rows. Each unique value in this column becomes one row in the result — typically your entity identifier such as product, machine, or cost centre.
Labels Column
Defines the output columns. Each unique value here becomes a new column header. Keep this bounded — categories, shifts, months — to avoid column explosion.
Values Column
Fills the pivoted cells. If more than one source row maps to the same index-label pair, the last value is used. Pre-aggregate your data first if you need sum or average.
Frequently asked questions
Everything you need to know about Pivot Columns in Infoveave.
Also in Pivot & Transpose — and what runs before & after
Transformations in the same family as Pivot Columns, often chained together in the same Infoveave workflow.
Part of Infoveave Data Automation
80+ transformations. Zero manual steps.
Pivot Columns is one of over 80 transformation activities available inside Infoveave workflows. Chain transformations together — no code, no exports, no waiting for IT.
Ready to see Infoveave in action?
