IF with a field containing multiple values

[#1]

There's a way to create a calculated variable linked to a condition starting from a field vector-like?

I.E. FIELD_CONDITION = 101,102,103 (this is an input object but this is not so important)

I want to put "A" for every record that have FIELD_SOURCE equal to one of the values in FIELD_CONDITION.

Obviously if I put this forumla: IF(FIELD_SOURCE=FIELD_CONDITION,'A','X')
QV resolve it in this way: IF('101'='101,102,103','A','X')

I wat something like this: IF('101'='101' OR '101'='102' OR '101'='103','A','X')

Thank you

[Miguel_Angel_Baeyens · Accepted solution]

Hello,

You can use MATCH function so (untested)

IF(MATCH(FIELD_SOURCE,FIELD_CONDITION), 'A', 'X')

or even maps in load time using ApplyMap function.

[#3]

MATCH function is perfect: IF(MATCH(FIELD_SOURCE,FIELD_CONDITION)<>0, 'A', 'X')

Thank you,
Bye