Right/Left Join with exclusion - Qlik Community

vadim_grab · ‎2018-09-22

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

Frank_Hartmann · ‎2018-09-22

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 · ‎2018-09-22



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