Append

Append lets you combine datasets by adding rows from other tables to your current (base) table. You control how columns align via simple mappings, preview the result instantly, and then save it as a refreshable view or a materialized table.

What is Data Appending?

Use Data Appending when you need to stack rows from other datasets underneath your base table, similar to a UNION ALL. It’s ideal for combining monthly files, merging exports from different systems, or consolidating similarly structured tables where column names or positions may differ.

How it works

1. Pick a base table (the dataset you opened Append from).
2. Select one or more datasets from your Organizer or Integrations to append.
3. Map columns from each appended dataset to the base table’s columns:
   • Map by Name matches columns with the same names.
   • Map by Index aligns columns by their order.
   • Remove Mappings clears all mappings for that dataset.
   • Per-column, you can also set a mapping manually or choose None to leave a base column blank for appended rows.
4. Preview shows a sample (first rows of the base plus a few rows from each appended dataset) so you can verify mappings before saving.
5. Save your result:
   • Save as View creates a refreshable view that rebuilds from sources.
   • Save as View to… lets you choose a folder/location.
   • Save as Table materializes the result into a new table.

Notes

• You must append at least one dataset to enable saving.
• The same dataset cannot be appended more than once; you cannot append the base dataset to itself.
• Unmapped base columns are left empty (null) in appended rows.
• Mapping changes sync to your workspace automatically.
• In shared read-only contexts, adding/removing datasets and changing mappings is disabled.
• Replace is shown in the menu but is not available yet (TBD).