Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Qlik Sense, how to filter in the load script with like

Hi community,

I've a table like this (this is a fake one):

load*Inline
[column1, colunm2
axc, 1
ac,2
axd,3
azx,2
az,1
a,1];

 

How I can filter all the string on column1 that does not contain "x"?

I've tried so far the opposite, like:

load*Inline
[column1, colunm2
axc, 1
ac,2
axd,3
azx,2
az,1
a,1]
where column1 like '%x%';

But first it does the opposite that I want (I do not want the ones with the x), furthermore it does not work. Have you already done something like this before?

Thanks in advance

Labels (3)
1 Solution

Accepted Solutions
Luminary
Luminary

Try this:

WHERE NOT column1 LIKE '*x*';

View solution in original post

4 Replies
Partner
Partner

Hi simotrab, try this... in the load script.

where FindOneOf(column1,'x')=0;

 

Tell us if it's fine.

regards.

Luminary
Luminary

Try this:

WHERE NOT column1 LIKE '*x*';

View solution in original post

Creator III
Creator III

First of all this works perfectly, thanks. Why it seems not working for "ac" for example (not important "a" and "c" , but "ac")?

Partner
Partner

It's work fine , with ..:

sampleTable:
load*Inline
[column1, colunm2
axc, 1
ac,2
axd,3
azx,2
az,1
a,1]
where not column1 like '*ac*';