Except
The Except component lets users compare two input flows (a primary table and a comparison table) and then output any rows from the primary table that do not also exist in the comparison table.
Because an entire row is compared, only overlapping columns are considered. Otherwise, all rows would always look unique and thus be passed on. Only unique rows are passed to the next component if there are duplicate rows in the primary input source.
The component generates multiple select queries separated by EXCEPT.
Properties
Name = string
A human-readable name for the component.
Cast Types = boolean
Choose whether to cast types.
- Yes: If the same-named column from both inputs has differing input types, attempt to cast them to a common type. This is not guaranteed to work. Please check your data carefully before proceding with this.
- No: If the same-named column from both inputs has differing input types, report an error and halt.
Primary Table = drop-down
Select the input source to treat as the primary table. The other input source becomes the secondary (comparison) table.