Minus Tool

[JBLove]

Under the join ribbon, could there be a new tool added called Minus?

This would behave similar to how SQL Minus works.  I think this tool could closely resemble the setup found in the union tool and provide the following functions:

• Ability to manually configure fields
• Automatically configure by name
• Automatically configure by position
• Ability to (de-select extraneous columns)
• Option to either include ALL rows, or just the distinct (similar to the minus and minus all behavior in SQL)

When doing validations in a workflow, this would provide a useful dq measure to use as a sanity check to ensure that for example loan numbers haven't been dropped from one point of the workflow to the next.

[KylieF]

We appreciate your feedback! If you haven’t yet be sure to check out our updated Submission Guidelines as it goes over our idea boards and the requirements to reach product in a bit greater detail. Be sure to check out the other product idea boards as well as like any other ideas that would benefit you!

[garycurtis123]

could either be like SQL minus or like Python Pandas compare ... either do the same function, just output differently.