It is possible to load multiple sources in a Stage and to combine them with set operators (UNION, MINUS, INTERSECT... depending on the stage's RDBMS supported operators).

Here is an example :

  • The stage has 3 sources
  • We can add a SET to the stage, by clicking the "Create set" button (indicated with a ➊ in the screenshot)
  • All the sets are displayed below the stage name (see ➋) and can be renamed
  • The stage expression may be for example : ([A] union [B]) minus [C]

 672 sets