Working with multiple datasets

You can add a dataset to the available datasets, move between datasets, and merge or append two datasets.

When combining datasets, two datasets are merged using a JOIN operator, and two matched datasets are merged using a UNION operator. Appended datasets are compatible and have an equivalent number of columns in the merged table.