Hello everyone,
I was wondering if there is a simple way to filter one Dataset by comparing key-values with another Dataset. Basically a Join but onlky keeping Left Attributes.
Example:
Dataset1
Project | SubID | moreAttributes from Dataset1 |
ABC | 1 | ... |
ABC | 2 | ... |
DE | 1 | ... |
DE | 2 | ... |
Dataset 2:
Project | SubID | different Attributes from Dataset2 |
ABC | 1 | ... |
ABC | 1 | ... |
ABC | 3 | ... |
ABC | 3 | ... |
DE | 2 | ... |
FG | 3 | ... |
I want to Filter Dataset 2 to only keep the ABC|1 and DE|2 rows because they match dataset 1. I am sure I could accomplish this via join and subsequently throw out all the Attributes that were introduced from dataset 1, but I was wondering if there is an easier way.
Thanks all