Defining a union view

I’m trying to understand the best way to approach a pretty common data modeling pattern in Grist.

Namely: suppose I import credit card transaction exports from several accounts. They have different formatting, etc., so I define derived columns for each table that reconcile column names and types, etc.

The next thing I want to do is define a table that collects all of the rows from all of the tables (just the common columns) together. In a system like dbt, I would define a view as a union of the source tables. I’m curious what would be the best approach in Grist.

1 Like