Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
load *
from A.qvd
where y <> 'USA';
inner join
load *
from B.qvd
where s <> 'Samsung';
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');
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;
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');