- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Right/Left Join with exclusion
Hi, All
Can somebody help to do Right/Left Join with exclusion.
My case - I have to tables:
Matched_Cat:
LOAD * INLINE [
Product, Category
Name3, Category2
Name4, Category3
Name5, Category4
Name6, Category6
];
Data:
LOAD * INLINE [
Product
Name1
Name2
Name3
Name4
Name5
Name6
Name7
];
Expected Result:
exclusion:
Product
Name1
Name7
Many thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe like this:
Matched_Cat:
Mapping LOAD * INLINE [
Product, Category
Name3, Category2
Name4, Category3
Name5, Category4
Name6, Category6
];
Data:
LOAD * INLINE [
Product
Name1
Name2
Name3
Name4
Name5
Name6
Name7
] where If(ApplyMap('Matched_Cat',Product,'#na')='#na',1,0)=1;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Matched_Cat:
LOAD * INLINE [
Product, Category
Name3, Category2
Name4, Category3
Name5, Category4
Name6, Category6
];
ProdData:
LOAD * INLINE [
Product
Name1
Name2
Name3
Name4
Name5
Name6
Name7
]
Where NOT Exists(Product)
;
May be this.?