8 Replies Latest reply: Jun 4, 2018 9:32 PM by Rob Wunderlich RSS

    Using WildMatch and another field as the expression (Different Tables)

    M Richman

      Hi Community,

       

      How would you do this if field1 and field2 are from separate tables and there is no possibility to join them?

       

      Referring to the following thread Re: Using WildMatch and another field as the expression

       

      Sunny's answer: If(WildMatch(Field1,'*' & Field2 & '*'), 'Match', 'No Match')

       

      Thanks in advance.