Condition on QVD joins

[#1]

Hi,

I have a scenario where I don't want to display rows for specific data values of a fields in QVD's.

Ex: A.qvd is having fields x,y,z;

      B.qvd is having fields x,s,t;

How to avoid values y='USA' and  s='SAMSUNG' after applying inner join on two QVD's, but want all the other values to display which falls in fields 'y' & 's'.

Thanks.

[Anonymous]

load *

from A.qvd

where y <> 'USA';

inner join

load *

from B.qvd

where s <> 'Samsung';

[#3]

You can try below:

Data:

LOAD X,Y,X From A.qvd Where not Match(Y,'USA') ;

Inner Join (Data)

LOAD X,S,T From B.qvd Where not Match(S,'Samsung');

[sunny_talwar · Accepted solution]

How to avoid values y='USA' and  s='SAMSUNG' after applying inner join on two QVD's, but want all the other values to display which falls in fields 'y' & 's'.

May be this:

Table:

LOAD x,y,z From A.qvd

Inner Join (Table)

LOAD x,s,t From B.qvd ;

NewTable:

NoConcatenate

LOAD *

Resident Table

Where not Match(y,'USA') and not Match(s,'Samsung');

DROP Table Table;

[qlikviewwizard]

Hi Please try below.

Thank you.

Table_Data:

LOAD x,y,z From A.qvd Where not Match(y,'USA') ;

Inner Join (Data)

LOAD x,s,t From B.qvd Where not Match(s,'Samsung');