What It Does
- Splits rows based on a selected column containing lists or multi-value arrays
- Each list item becomes its own row — all other columns are preserved
- Designed for lead enrichment, pipeline hygiene, or flattening JSON-like structures
- Supports arrays or comma-separated fields already parsed as lists
- Download-ready output in both CSV and Parquet
🔄 Whether you’re flattening tech stacks or cleaning up tags, this node helps normalize list-based columns into usable rows.
🏁 Getting Started
1
Add the Node
Drag in the Split Data node from your toolbox.
2
Choose a Column to Split
Select a column from the dropdown that contains lists or array-like data.
3
Run the Node
Each list item will become its own row — with all other data intact.
Inputs
🛠️ Required Fields
- Column to Split (✅)
Select a column with list-style values to explode into multiple rows.
Why it matters: This controls which field is broken apart and normalized.
Output
A new dataset with exploded rows:- Every list item becomes its own row
- All other fields are duplicated across the new rows
- Output available in CSV and Parquet formats
How It Works
- Loads input dataset and parses the selected list column
- Validates that the field contains actual list values
- Uses row explosion to generate one row per list item
- Preserves all original columns and values
- Returns a clean, flattened table
🚀 Example Use Cases & Prompts
| Use Case | Prompt or Setup Example |
|---|---|
| Break out tags or labels | Split the tags field |
| Normalize tech stacks | Explode the technologies_used |
| Unpack product bundles | Use the products list column |
✨ Pro Tips
⚠️ Important Considerations
🛠 Troubleshooting & Gotchas
| Symptom | Likely Cause | Quick Fix |
|---|---|---|
| Nothing splits | Selected column isn’t a list | Check formatting — upstream transform may be needed |
| Output is blank | Lists were null or empty | Clean your data or apply filters first |
| “Column not found” error | Column was renamed or dropped | Re-select the correct column |
📝 FAQ
Can I split a column with comma-separated values?
Can I split a column with comma-separated values?
Only if the values have already been parsed into actual lists. Use a transform step if they’re still plain strings.
What happens to other columns?
What happens to other columns?
They’re duplicated across all new rows to keep the dataset structure consistent.
Can I split multiple columns at once?
Can I split multiple columns at once?
Not yet — but you can use multiple Split Data nodes, one per column.
💰 Pricing
The Split Data node is free — no credits required.
Clean structure, clean plays. Split your lists and turn complexity into rows you can actually work with.