Except

Definition

Returns A - B Table, where A is the left input and B the right one.

Options

1. all:

   • Def: Returns A - B Table, where A is the left input and B the right one, lets the duplicated rows.

2. distinct:

   • Def: Returns A - B Table, where A is the left input and B the right one, removes the duplicated rows after the operation.

3. byNameAll:

   • Def: Returns A - B Table, where A is the left input and B the right one, lets the duplicated rows.

4. byNameDistinct:

   • Def: Returns A - B Table, where A is the left input and B the right one, removes the duplicated rows after the operation.

Additional Comments

The 2 tables need to have the same format (same columnName in the same order).

1. all:

   • The 2 tables need to have the same format (same columnName in the same order).

2. distinct:

   • The 2 tables need to have the same format (same columnName in the same order).

3. byNameAll:

   • Column don't have to be ordered.

4. byNameDistinct:

   • Column don't have to be ordered.