Exclude data from database in my loadscript in Qvd

[bratman93]

Hi everyone. I have some contaminated data in my database which i want to exclude from my data load. 

This is my load script. I do NOT want to load data where the column MODULE contains the value "username".

Is there a easy way I can fix this in the load script?

[vinieme12]

Add a where clause to your SQL query 

SQL Select field1,field2,

From somedb.tablename 

WHERE module<>'username' ; 

You can use below

module!=username' 

Or 

Module not in ('username') 

You can refer below site for more on learning SQL 

https://www.w3schools.com/sql/

[bratman93]

But is there a way to do it Qlik instead of the database?

[BrunPierre]

As below

LOAD MODULE,
....
TIMESTAMP(CREATEDATE,'YYYY-MMPDDhh:mm:ss') as ErrandCreateDate

Where Not Wildmatch(MODULE,'*username*');

SQL SELECT
...
FROM

[bratman93]

thanks my man! did the trick, can I put more than one condition in the same wildmatch?

[BrunPierre]

Of course!

See here to learn more: wildmatch - script and chart function