The Merge operation creates a new query from two existing queries.
An Expand operation adds columns from a related table into a primary table.
Privacy Levels prevent a user from inadvertently combining data from multiple data sources, which may be private or organizational
You can perform two types of merge operation: Intermediate Merge or Inline Merge.
After a Merge operation, you can expand a Table link column to add columns from the related table into a primary table. Once a column is expanded into the primary table, you can apply filters and other transform operations.
This helps avoid multiple copies of matching data in a row. But which should be the primary table?