Load Basic

[Mahamed_Qlik]

Hi

I have field as below :

A1
A2
A3
A5 ......till A2000

I want to apply filter to load only less than A150.

[rubenmarin]

Hi, if all the values has a letter and a number you can use something like:

LOAD * from/resident... Where Mid(FieldName,2)<150;

[anat]

if you have other letters then go with purgechar like below:

LOAD * Where PurgeChar(ID,'ABCDEFGHIJKLMNOPQRSTUVWXYZ')>5;
LOAD * Inline [
ID
A1
A2
A3
A4
A10
A11
A12

];