Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Luminary
Luminary

Try this:

WHERE NOT column1 LIKE '*x*';

View solution in original post

4 Replies
Highlighted
Partner
Partner

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

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

 

Tell us if it's fine.

regards.

Highlighted
Luminary
Luminary

Try this:

WHERE NOT column1 LIKE '*x*';

View solution in original post

Highlighted
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")?

Highlighted
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*';