Equivalent of SQL Minus operation in datameer

Comments

1 comment

  • Alan Mark

    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

    0
    Comment actions Permalink

Please sign in to leave a comment.