Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I am stuck with a situation where I need to exclude multiple values in load script from a field in Qliksense. I have tried following -
Query 1:
SQL SELECT *
FROM HIVE.DBName.Table Name where [Field] <> 'value1' or [Field] <> 'value2' or [Field] <> 'value3'; I can still see the values after load
You need to use SQL query syntax in a SQL SELECT query.
Try this:
SQL SELECT *
FROM
HIVE.DBName.TableName
WHERE Field NOT IN ('Value1','Value2','Value3');
Vegar's reply is best; if you want to keep the syntax in Qlik language you will need to use the Query4 syntax (or your syntax from Query 1):
Load *
Where not match(field,'value1','value2');
SQL SELECT *
FROM HIVE.DBName.Table;
This will use a preceding load from the HIVE database; although all rows will be returned to Qlik from the HIVE database. Again, Vegar's response to inject the where clause using native database language is best.
You need to use SQL query syntax in a SQL SELECT query.
Try this:
SQL SELECT *
FROM
HIVE.DBName.TableName
WHERE Field NOT IN ('Value1','Value2','Value3');
Hello Vegar,
This solution works, can I extend this condition by adding 'and' date>=20190101; further?
Vegar's reply is best; if you want to keep the syntax in Qlik language you will need to use the Query4 syntax (or your syntax from Query 1):
Load *
Where not match(field,'value1','value2');
SQL SELECT *
FROM HIVE.DBName.Table;
This will use a preceding load from the HIVE database; although all rows will be returned to Qlik from the HIVE database. Again, Vegar's response to inject the where clause using native database language is best.
Hello Pirolli,
Yes this helps too. Thank you.
Any thoughts on this
nesting another condition in where clause after excluding values filter using date field