How to use more than 250 value in OR clause

[#1]

I have QVW,which records from QVD.

I need to put condition.below like

IF(GFCID='111' OR GFCID='22' OR GFCID='33' OR ....like that...I have 250 GFCID...

how achive this,PLease ahre example.

.

[Anonymous]

Hi,

you can move these values in to script a separate lookup a table and have a apply map or join.

or

else add a additional flag column with these values and assign aa flag to these set of values and use in your reportng.

Regards,

Chinna

[maleksafa]

no applymap and no match function, check my previous comment; load them in a table with two columns, first one is the GFCID and the second one is your flag.

[alexandros17]

The best approach is to realize a table (with load * inline) containing all your value so you manage only a field and if you need to include or exclude another value you just open an excel (or txt) file.