Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to exclude vales when loading script.
I know i can use match() but i want to exclude 3 values. is there any negative function for match
TableName:
Load Customer, Sales, Date, InvoiceNumber From SalesTable
Where Not Match(Customer, 'A','B','C');
Something like above..
Hi,
use a WHERE NOT EXISTS() clause in the LOAD to exclude those?
Kindly Give example to explain your problem.
Regards,
Kaushik Solanki
TableName:
Load Customer, Sales, Date, InvoiceNumber From SalesTable
Where Not Match(Customer, 'A','B','C');
Something like above..
To exclude values
Where Match(field, 'ValuetoExclude') = 0
or
Where Not(Match(field, 'ValuetoExclude')) // if that is more readable
if you have only 3 values than use the where clause
like
LOAD
A,
B,
C,
D
from
table
where A='value1' or A='value2' or A='value3' ;
or if you have multiple fields than
where A='value1' and B='value2' and C='value3'
use
sampl:
Load
*,
cust as CustomerTab
Resident sales
where not exists ([Name], [age],[salary]);
You can use not Match()
Hi,
Always use Mixmatch() so even if there is any upper/lower casing differences then also it works.
Note: Qlikview is case sensitive. A and a is not the same in Qlikview.
Where Not MixMatch(Customer, 'A','B','C');
Hope this helps you.
Regards,
Jagan.