Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
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.?