PLEASE HELP ME

[#1]

STATUS
ACTIVE
DISCONECT
INACTIVE
null
RECONECT
0
50
3015453
3047853
3090030
4319411
4830094
5508020
5555873
5749025
5773422
6604549
6909241

IN THE ABOVE STATUS FIELD I NEED TO LOAD ONLY (ACTIVE,DISCONNECT,INACTIVE, RE CONNECTION) VALUES ONLY

THANKS

RAMU.

[swuehl · Accepted solution]

LOAD STATUS

FROM YourTableSource

WHERE Match(STATUS, 'ACTIVE','DISCONNECT','INACTIVE', 'RE CONNECTION');

[avinashelite]

if your loading it from an SQL source than handel it in the SQL

like SELECT * from

table.name

where STATUS in ('ACTIVE','DISCONNECT','INACTIVE', 'RE CONNECTION')

if you want to handel it in QV then try like this,

LOAD *

from

table

where STATUS='ACTIVE' or STATUS='DISCONNECT' or STATUS='INACTIVE' or STATUS='RE CONNECTION';