Joining datasets, filtering out data, and aggregating data

Use a SQL operation to filter out data, join datasets, or aggregate data by using the Execute SQL activity.

The activity includes four input ports. Input tables can be given custom names that are reused when building the query. You can join up to four different datasets into one.

To aggregate data and use a subset of the dataset, perform SQL aggregation operations across columns.