Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
You can use MATCH function so (untested)
or even maps in load time using ApplyMap function.IF(MATCH(FIELD_SOURCE,FIELD_CONDITION), 'A', 'X')
Hello,
You can use MATCH function so (untested)
or even maps in load time using ApplyMap function.IF(MATCH(FIELD_SOURCE,FIELD_CONDITION), 'A', 'X')
MATCH function is perfect: IF(MATCH(FIELD_SOURCE,FIELD_CONDITION)<>0, 'A', 'X')
Thank you,
Bye