Unfold Column
Infoveave Data Automation — Pivot & Transpose
Every unique category value becomes its own binary column — 1 if the row matches, 0 if it does not.
Machine learning models, pivot analysis, and many BI tools require categories to be expressed as binary indicator columns rather than a single text column. Unfold Column automates that encoding step: it scans the selected column for all unique values and creates a new 0/1 column for each one — so a Status column with three values becomes three indicator columns — without any manual dummy variable coding or pivot table setup.
What Unfold Column does
Convert unique category values into binary indicator columns in Infoveave workflows. One-hot encode status, type, or tag columns for machine learning, filtering, and pivot analysis.
When to use Unfold Column
- You are preparing a categorical column for a machine learning model that requires numerical feature inputs rather than text categories
- You want to create indicator columns from a status, type, or tag field so you can filter, sum, or aggregate by each value independently
- You need to produce a pivot-style layout where each category value becomes its own column for a dashboard or export template
- You want to replace a text category column with binary flags for analysis without removing the original row structure
When to avoid it
- Your column has too many unique values — unfold works best on low-cardinality columns (typically 10 or fewer unique values); high-cardinality columns produce too many indicator columns
- You want to expand a delimited multi-value text field — use Split and Unfold for that case (it handles comma-separated tags in a single cell)
- You want to expand array values into rows rather than into columns — use Fold an Array for that
Where it fits in your Infoveave automation
Unfold Column 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 Unfold Column
Real scenarios where this transformation saves hours of manual work.
Encode Machine Status for Downtime Prediction Model
A manufacturing data science team feeds machine status data into a predictive maintenance model. The Status column contains values Running, Idle, Warning, and Fault. Unfold Column creates four binary indicator columns — one per status — so the model receives numerical features instead of a text column. The workflow encodes the status automatically on every data refresh, ensuring the model always receives correctly formatted input.
Create Binary Diagnosis Flags for Risk Stratification
A healthcare analytics team needs binary flags for each primary diagnosis category in a patient dataset. The primary Diagnosis column contains four values representing the major diagnostic groups. Unfold Column generates one indicator column per diagnosis group, letting the risk scoring model treat each diagnosis as an independent numeric feature rather than a categorical string.
Expand Order Channel Column for Channel Attribution Analysis
A retail analytics team wants to analyze revenue by order channel in a pivot-compatible format. The Channel column has values Online, In-Store, and Marketplace. Unfold Column produces three binary columns — Channel_Online, Channel_In-Store, Channel_Marketplace — so the BI tool can sum revenue by channel by simply multiplying the revenue column by each indicator column without requiring a GROUP BY or manual filter.
See Unfold Column in action
Input data (left) is transformed using the configuration below. The output table (right) is ready for dashboards or downstream steps.
CategoryDisabledInput Data
| ID | Category |
|---|---|
| 1 | A |
| 2 | B |
| 3 | A |
| 4 | C |
| 5 | B |
Output Data
| ID | Category_A | Category_B | Category_C |
|---|---|---|---|
| 1 | 1 | 0 | 0 |
| 2 | 0 | 1 | 0 |
| 3 | 1 | 0 | 0 |
| 4 | 0 | 0 | 1 |
| 5 | 0 | 1 | 0 |
Configuration
Key fields to configure in the Infoveave workflow builder. Full reference available in the documentation.
Column to Unfold
Select the categorical column whose unique values will become binary indicator columns. The activity scans the column for all distinct values and creates one new 0/1 column for each unique value. The new column names are derived from the original column name combined with each unique value.
Include Original
When enabled, the original categorical column is retained in the output alongside the new binary indicator columns. When disabled (the default), the original column is replaced by the expanded binary columns. Enable Include Original when you need both the text category and the binary flags in the same output — for example, when the text label is still needed for display while the binary columns are needed for calculation.
Frequently asked questions
Everything you need to know about Unfold Column in Infoveave.
Also in Pivot & Transpose — and what runs before & after
Transformations in the same family as Unfold Column, often chained together in the same Infoveave workflow.
Part of Infoveave Data Automation
80+ transformations. Zero manual steps.
Unfold Column 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?
