topic Select & NOT LIKE doesn't work properly in QlikView

Select & NOT LIKE doesn't work properly

Mon, 27 Apr 2009 13:49:06 GMT

Dear all,

I did the following code but during upload the NOT LIKE sentences don't work ?

Is it a mistake on sintax or something else.

Thanks, Giovanni

SQL SELECT

P2PRENO0.P2AIP, P2PRENO0.P2NNP, P2PRENO0.P2PAR, P2PRENO0.P2STR, P2PRENO0.P2DAP, P2PRENO0.P2OAP,

P2PRENO0.RNLIB, P2PRENO0.P2NTR, P2PRENO0.P2NRP, P2PRENO0.P2DAI, P2PRENO0.P2ORI, P2PRENO0.P2AGD,

P2PRENO0.P2ORA, P2PRENO0.P2NTA, P2PRENO0.P2NPA, P2PRENO0.P2NOT, P2PRENO0.P2FFO, P2PRENO0.P2FTP,

P2PRENO0.P2TPA

AS P2TPC, P2PRENO0.P2PGA, P2PRENO0.P2SPO, P2PRENO0.P2CPR, P2PRENO0.P2PAN AS P2PAN_PREN,

P2PRENO0.P2URZ, P2PRENO0.P2RPS, P2PRENO0.P2P09

FROM

UGSD00.P2PRENO0

WHERE

P2PAN <> 'A' AND P2AIP >= 2009 AND P2AIP <= 2010 AND P2FTP <> 'I' AND

P2STR

NOT LIKE 'LB%' AND

P2STR

NOT LIKE 'DM%' AND

P2STR

NOT LIKE 'AC%'

AND P2NTR NOT LIKE 'ALESSANDRA'

AND P2NTR NOT LIKE 'AULA%'

AND P2NTR NOT LIKE 'QPADEV%'

AND P2NTR NOT LIKE 'CED%'

;

Select & NOT LIKE doesn't work properly

Mon, 27 Apr 2009 13:55:06 GMT

What kind of database are you extracting from?

Select & NOT LIKE doesn't work properly

Mon, 27 Apr 2009 14:05:32 GMT

Hi,

Try the following sql statement.

SQL SELECT

P2PRENO0.P2AIP, P2PRENO0.P2NNP, P2PRENO0.P2PAR, P2PRENO0.P2STR, P2PRENO0.P2DAP, P2PRENO0.P2OAP,

P2PRENO0.RNLIB, P2PRENO0.P2NTR, P2PRENO0.P2NRP, P2PRENO0.P2DAI, P2PRENO0.P2ORI, P2PRENO0.P2AGD,

P2PRENO0.P2ORA, P2PRENO0.P2NTA, P2PRENO0.P2NPA, P2PRENO0.P2NOT, P2PRENO0.P2FFO, P2PRENO0.P2FTP,

P2PRENO0.P2TPA

AS P2TPC, P2PRENO0.P2PGA, P2PRENO0.P2SPO, P2PRENO0.P2CPR, P2PRENO0.P2PAN AS P2PAN_PREN,

P2PRENO0.P2URZ, P2PRENO0.P2RPS, P2PRENO0.P2P09

FROM

UGSD00.P2PRENO0

WHERE

P2PAN <> 'A' AND P2AIP >= 2009 AND P2AIP <= 2010 AND P2FTP <> 'I' AND

P2STR

NOT LIKE 'LB%' AND

P2STR

NOT LIKE 'DM%' AND

P2STR

NOT LIKE 'AC%'

AND P2NTR NOT LIKE 'ALESSANDRA%'

AND P2NTR NOT LIKE 'AULA%'

AND P2NTR NOT LIKE 'QPADEV%'

AND P2NTR NOT LIKE 'CED%'

Select & NOT LIKE doesn't work properly

Mon, 27 Apr 2009 14:06:31 GMT

Are you maybe using MySQL 5, because I know there was a bug with NOT LIKE in the past.

-Did you try this format: NOT(P2NTR LIKE 'CED%')
-Or including table names will sometimes help:
UGSD00.P2PRENO0.P2NTR NOT LIKE 'CED%

Good luck!

Select & NOT LIKE doesn't work properly

Mon, 27 Apr 2009 14:09:48 GMT

AS400 DB2

Thanks

Select & NOT LIKE doesn't work properly

Mon, 27 Apr 2009 14:12:38 GMT

What do you mean by "doesn't work". No results? Wrong results?

Try executing the statement with a tool other than QlikView.

Select & NOT LIKE doesn't work properly

Mon, 27 Apr 2009 14:26:34 GMT

At least 'NOT LIKE' works for AS400 DB2.

Probably something else wrong with your query.

What error do you get?

Select & NOT LIKE doesn't work properly

Mon, 27 Apr 2009 14:34:11 GMT

The result is that I found "also" the rows that has the "NOT LIKE" statement .

It seems that this part (where I put not like...) would be not influencing the upload.

Thanks

Select & NOT LIKE doesn't work properly

Mon, 27 Apr 2009 19:56:23 GMT

It seems really the same .

Where did you modify it ?

Thanks