Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
razvan_brais
Creator III
Creator III

Loading Table

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.

1 Solution

Accepted Solutions
avinashelite

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

View solution in original post

4 Replies
avinashelite

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
Creator III
Creator III
Author

Thank you for your answer.

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

ramchalla
Creator II
Creator II

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
Creator III
Creator III
Author

Thank you for your answer.