Left Anti- All from left that are NOT in right
Left Anti- All from left that are NOT in right
Select Your Currency
Get & Transform- Excel’s data cleanup tool (aka PowerQuery)
-
Compare/ reconcile lists
- Compare lists to each other
- Left Outer- All from left matching from right
- Right Outer- All from right matching from left
- Full Outer- All from left and right
- Inner- Only the common items
- Left Anti- All from left that are NOT in right
- Right Anti- All from right that are NOT in left
- Merge Queries Examples
