Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
vadim_grab
Creator
Creator

Right/Left Join with exclusion

Hi, All

Can somebody help to do Right/Left  Join with exclusion.

VennDiagram1.pdf - Google Chrome 2018-09-22 16.48.41.png

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


2 Replies
Frank_Hartmann
Master II
Master II

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;

nsetty
Partner - Creator II
Partner - Creator II

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.?