Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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?
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.
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;
qvd:
LOAD item FROM item.qvd (qvd);
excel:
noconcatenate LOAD item FROM Excel.xls;
Left join (excel) load item, 1 as Check Resident qvd;