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:
Solved! Go to Solution.
Right now, i have it setup like the below, which looks quite tedious to me, so im checking if you know a simpler way.
@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.