Help Center
Data

Building a mapping

Step-by-step: pick a source, pick a schema, wire up the fields, preview the result.

Building a mapping

You need editor or admin access.

Steps

  1. Open the project, then Mappings → New mapping.
  2. Pick a data source.
  3. Pick a schema to produce.
  4. For each schema field, choose a source column (or leave it empty to use the schema default).
  5. Optionally add row filters to skip source rows you do not want.
  6. Save.

The mapping page shows a resolve preview — the first rows as they look after the mapping runs. If a field looks wrong, adjust and re-preview without committing.

Non-trivial fields

  • Concatenation — join two or more columns with a separator. Useful for first_name + " " + last_name.
  • Constant — hard-code a value that every row should get ("LIVE").
  • Computed — a small expression over the source columns. Your admin may have configured helpers; see Computed fields (coming) for the reference.

When the source changes

If a source column is renamed or removed, every mapping that used it shows the affected field as "missing". Open the mapping and pick a replacement column — the preview updates immediately.