Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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*';
vizmind.eu

View solution in original post

4 Replies
jupitopino
Partner - Contributor III
Partner - Contributor III

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*';
vizmind.eu
simotrab
Creator III
Creator III
Author

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 - Contributor III
Partner - Contributor III

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