How to check field values are present in the field or not.

[#1]

Hi,

I am trying to check filed value is present in that field or not.

Ex:

Field:Item and it values are 1 to 10.

If i pass the values from 1 to 10,it has to select that value else deselect the value.

Can any one help on this .

Thankyou

Anil.

[swuehl]

Sorry, I don't understand.

How do you 'pass the value'? When you are trying to select a non existing value in a list box (by search), doesn't it work like requested?

[#3]

initially i will load field values from qvd (from 1 to 10)

EX:load item from item.qvd.

NOConcatenate load item from excel.(for values like 1,11,2,3)

now i want to cross check this item values with values that are loaded from qvd.

Is it possible to do so.

[swuehl · Accepted solution]

You can use EXISTS() to check for existence of fied values:

LOAD item as ItemQVD

FROM item.qvd (qvd);

LOAD if(exists(ItemQVD, item), 'Exists in QVD', 'Does not exist in QVD') as Check,

          item

FROM Excel.xls;

[maxgro]

qvd:

LOAD item FROM item.qvd (qvd);

excel:

noconcatenate LOAD item FROM Excel.xls;

Left join (excel) load item, 1 as Check Resident qvd;