where

[#1]

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

[#2]

SQL SELECT *

FROM '115_PGC_RELACIONADO'

WHERE CTA_MAYOR NOT LIKE 'Z*'

[Miguel_Angel_Baeyens · Accepted solution]

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

[#4]

Thank you, everything clear!!