Transform Maps

Jace Benson

Table of content
  1. When to Use Robust
  2. Key Differences
  3. Multi-Stage Transforms
  4. Further Reading

Docs

Robust Transform Maps are the next level up from regular Transform Maps. They add multi-stage transform capabilities, conditional mapping, and better error handling for complex imports.

When to Use Robust

Regular Transform Maps work fine for simple imports — one staging table, one target table, straightforward field mappings. But when you need to:

That's when Robust Transform Maps come in.

Key Differences

Feature Transform Map Robust Transform Map
Target tables One One or more
Multi-stage No Yes — chain transforms together
Conditional mapping Limited Full script conditions
Error handling Basic Per-stage error handling
Field map reuse Per-map only Template-based field maps

Multi-Stage Transforms

A robust transform can run multiple stages, each with its own target table and mapping. This is useful for:

  1. Stage 1: Create the parent record (e.g., a user record)
  2. Stage 2: Create related records (e.g., group memberships)
  3. Stage 3: Update related records (e.g., asset assignments)

Each stage can depend on the previous stage's output for reference values.

Further Reading