Loading Table

[razvan_brais]

Hy there. I`m trying to LOAD data from a table but I want to exclude some info when a String does not contain a subString.

The querry looks like this

LOAD

  COLUMNS;

SQL SELECT *

FROM MY_TABLE

WHERE COLUMN_NAME not like '*subString*';

But this isn`t working. It brings all the data.

What am I doing wrong?

Thank you.

[avinashelite · Accepted solution]

Which is your back end database??

SELECT *

FROM MY_TABLE

WHERE COLUMN_NAME not like '*subString*'

this is actually the SQL query part , try executing this against the database and check the error

[razvan_brais]

Thank you for your answer.

I solved it. It was just a simple sql query.

[ramchalla]

Hi Razvan,

You can use the below as an alternative solution.

LOAD

  COLUMNS;

SQL SELECT *

FROM MY_TABLE

WHERE not WildMatch(COLUMN_NAME,'*subString*');

[razvan_brais]

Thank you for your answer.