Load Table where string not equal to...?

[ahmar811]

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

[mayankraoka]

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.

[Gysbert_Wassenaar · Accepted solution]

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

[ahmar811]

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

[ahmar811]

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

[avinashelite]

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