This content has been marked as final. Show 3 replies
Is there an expression that can find matches between substrings of two fields that both have comma delimitted substrings?
Field_1 = 'USA', 'Italy', 'Japan'
Field_2 = 'Jamaica', 'Italy', 'Australia', 'Korea', 'China', 'Chile', 'Mexico'
Is there an expression I can use in a text object or a chart, to tell that Field1 and Field 2 do have a match WITHOUT using the load script?
In the example above, both fields have 'Italy'. The expression would help to determine that both Field_1 and Field_2 contain 'Italy'.