SQL error

[#1]

Hi, what's wrong in this script?

[EBAN_W]:

ADD

LOAD *

;

  SQL

    SELECT DISTINCT MATNR, TXZ01

    FROM EBAN

    WHERE Right(MATNR,1) = '4'

  ;

But this scrpt works:

[EBAN_W]:

ADD

LOAD *

;

  SQL

    SELECT DISTINCT MATNR, TXZ01

    FROM EBAN

    WHERE MATNR = '4000000'

  ;

Thanks

[#2]

Hi Javier

You can't use QlikView functions in WHERE clause of SQL query. This query is send to database thus only DBMS functions are supported.

Lukasz

[#3]

Hi,

I have this too, because our version of SQL doesn't deal with Right( function, only with substr.

Right(MATNR,1) is then translated into Substr(MATNR,Length(MATNR),1). This is in Oracle SQL.

Hope this helps.

[#4]

You probably need something like SUBSTR(MANTR, -1) = '4' instead of RIGHT

[#5]

Hi Javier,

The SQL Function let you write code with the same syntax and functions as your Database would have, so that is a space where you make a query.

[Anonymous · Accepted solution]

Javier

The reply by Lukasz is absolutely correct.

For SQL on Oracle [other brands of SQL may vary] you would need :

   SELECT DISTINCT MATNR, TXZ01

    FROM EBAN

    WHERE MATNR like '%4'  ;

Assuming I have understood correctly and need the last character to be 4.

Best Regards,     Bill

[#7]

Thanks, This was the script, really I need the number that star with 4, and the functions Left, Rigth, don't work.

[EBAN_W]:

ADD

LOAD *

;

  SQL

    SELECT DISTINCT MATNR, TXZ01

    FROM EBAN

    WHERE MATNR LIKE '4%'

  ;

[jaimeaguilar]

Hi,

It is important to mention that when you're extracting data from a Database, QlikView script can be divided in 2 segments: