topic Load Table where string not equal to...? in QlikView

Load Table where string not equal to...?

ahmar811 — Wed, 30 Sep 2015 09:48:23 GMT

i want to load empNameB field which are not equal to 'A*' (begin from A letter) in Table

Table:

LOAD * INLINE [
Sales,empNameB
11,aa
12,AA
13,BB
14,CC
15,DD
16,EE
];

temp:
load empNameB as TEMP_field Resident Table where empNameB<>'A*';

but isnt work

plz help

Thanks

Re: Load Table where string not equal to...?

mayankraoka — Thu, 01 Oct 2015 00:50:16 GMT

You need to drop the original table also .or else directly right the where

clause in inline load only.please let me know if this works.

Re: Load Table where string not equal to...?

Gysbert_Wassenaar — Thu, 01 Oct 2015 06:03:55 GMT

temp:
load empNameB as TEMP_field Resident Table where wildmatch(empNameB,'A*');

or if you need a case sensitive match:

temp:
load empNameB as TEMP_field Resident Table where left(empNameB,1)<>'A';

Re: Load Table where string not equal to...?

ahmar811 — Thu, 01 Oct 2015 06:19:54 GMT

temp:
load empNameB as TEMP_field Resident Table where left(empNameB,1)<>'A';

this statement work fine but its work for case sensitive match

i think your first statement should be like this :

temp:
load empNameB as TEMP_field Resident Table where wildmatch(empNameB,'A*')=0;

this statement works for case-sensitive and case-insensitive

Re: Load Table where string not equal to...?

ahmar811 — Thu, 01 Oct 2015 06:32:14 GMT

Yes you can wirte where condition after inline like

Master:

LOAD * INLINE [
Sales,empNameB
11,aa
12,AA
13,BB
14,CC
15,DD
16,EE

] where wildmatch(empNameB,'A*')=0;

and its work fine

Re: Load Table where string not equal to...?

avinashelite — Thu, 01 Oct 2015 06:53:57 GMT

if your facing case-sensitive problem try to convert both the string to upper case and then compare the same this should solve the issue . Hope this helps you