topic Re: Loading Table in QlikView

Loading Table

razvan_brais — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Loading Table

avinashelite — Tue, 23 Aug 2016 09:00:51 GMT

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

Re: Loading Table

razvan_brais — Tue, 23 Aug 2016 09:02:10 GMT

Thank you for your answer.

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

Re: Loading Table

ramchalla — Tue, 23 Aug 2016 10:22:54 GMT

Hi Razvan,

You can use the below as an alternative solution.

LOAD

COLUMNS;

SQL SELECT *

FROM MY_TABLE

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

Re: Loading Table

razvan_brais — Tue, 23 Aug 2016 11:19:12 GMT

Thank you for your answer.