Equivalent of SQL Minus operation in datameer
Is there any operation in Datameer that will yield the same result as SQL MINUS operation. Consider I have 10k rows in Sheet1 and 200 rows in Sheet2. I want to get 10k-200 rows in a sheet. Both sheets 1 and 2 have the same columns. How do I achieve this in Datameer?
-
Hi Pallavi,
The SQL Minus operator performs a Left Outer Join. You can see the Venn Diagram describing this here: https://www.techonthenet.com/sql/minus.php
So, start with your first sheet 1 and click the Join button. In the Simple join dialog, click the dropdown and change the Join Type to Left Outer Join.
Drag your two columns from the two sheets into the "Drop Here" fields to build the join.
Expand the "Included columns" section at the bottom of the dialog and select only the columns you would like to keep.
Finally, Click Create Joined Sheet.
I believe this result will give you what you're looking for.
Let me know if you have any further questions,
Alan
Please sign in to leave a comment.
Comments
1 comment