Col 1 look up to Col 2

[samxhander09]

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]

Right now, i have it setup like the below, which looks quite tedious to me, so im checking if you know a simpler way.

[Bren_Spill · Accepted solution]

@samxhander09 -  does the attached work for you?

[KGT · Accepted solution]

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.