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
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
simotrab
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
Ivan_Bozov
Luminary
Luminary

Try this:

WHERE NOT column1 LIKE '*x*';

View solution in original post

4 Replies
jupitopino
Partner
Partner

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

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

 

Tell us if it's fine.

regards.

Ivan_Bozov
Luminary
Luminary

Try this:

WHERE NOT column1 LIKE '*x*';

View solution in original post

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

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