topic where in QlikView

where

Tue, 07 Sep 2010 15:17:22 GMT

Hi community

I´m sure it´s something easy:

I need to load a partial table:

SQL

FROM

CTA_MAYOR NOT LIKE 'Z*';

`115_PGC_RELACIONADO`

WHERE

SELECT *

In SQL that sentence has sense, but here it doesn´t work. How could I do that?

Thanks, Fiber

where

Tue, 07 Sep 2010 15:19:13 GMT

SQL SELECT *

FROM '115_PGC_RELACIONADO'

WHERE CTA_MAYOR NOT LIKE 'Z*'

where

Miguel_Angel_Baeyens — Tue, 07 Sep 2010 15:39:25 GMT

Hello,

You always have at least two ways of loading that information. First, passing all conditions to driver, as you have written above. Second, you can perform that where in the script

LOAD * WHERE LEFT(CTA_MAYOR, 1) <> 'Z'; SQL SELECT * FROM 115_PGC_RELACIONADO;

It depends on how heavy the query may result and later performance of your script.

Hope that helps

where

Tue, 07 Sep 2010 15:44:21 GMT

Thank you, everything clear!!