SetOperation
SQL Gem
Use the SetOperation Gem to perform addition or subtraction of rows from Models with identical schemas and different data.
Parameters
| Parameter | Description | Required |
|---|---|---|
| Model 1 | First input Source | True |
| Model 2 | Second input Source | True |
| Model N | Nth input Source | False |
| Operation type | Operation to perform - Union: Returns a Model containing rows in any one of the input Sources, while preserving duplicates.- Intersect: Returns a Model containing rows in all of the input Sources, while preserving duplicates. - Except: Returns a Model containing rows in the first Source, but not in the other Sources, while preserving duplicates. | True |
info
To add more input Sources, simply click + icon on the left sidebar
Examples
Operation Type - Union
Operation Type - Intersect
Operation Type - Except
