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

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

    Miguel Rijk

      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.