Hi Community! I have 2 columns that shares common fields. What I want to do is to check Whether Code_Left contains ANY value from Code_right and return as TRUE(if contains) or FALSE(if does not contain any). See below for reference:
@samxhander09 - does the attached work for you?
Try this:
IF Contains(ToString([Right_Code]), ToString([Code]))THEN "True"ELSE "False"ENDIF
This converts them to string in-line, but you could always convert to string beforehand if you wanted.
Right now, i have it setup like the below, which looks quite tedious to me, so im checking if you know a simpler way.
