Advanced Mode
Multi-Source Flows
Combine data from multiple sources
Multi-Source Flows
Advanced Mode allows you to combine data from multiple sources into a single flow.
Use Cases
Combining SIS and HR Data
- Student data from the SIS
- Staff data from HR system
- Merged into unified output for ASM
Multiple School Locations
- Each school exports separately
- Merge into single organization hierarchy
- Publish as one dataset
Using the Merge Node
Adding a Merge Node
- Drag the Merge node from the palette
- Connect multiple source outputs to merge inputs
- Connect merge output to next step
Conflict Resolution
When the same entity exists in multiple sources:
| Strategy | Description |
|---|---|
| First wins | Keep data from first source |
| Last wins | Keep data from last source |
| Manual | Review and choose per conflict |
| Merge fields | Combine non-conflicting fields |
Best Practices
- Match sourcedIds - Use consistent IDs across sources
- Test incrementally - Preview after each source
- Document sources - Name nodes clearly
- Validate merged data - Check for duplicates
Multi-source flows are more complex to debug. Start with Standard Mode and migrate to Advanced only when needed.