1 Reply Latest reply on Jun 19, 2018 7:42 AM by Matthew Risley

    join tables with string search function

    oscar vicente

      hello

       

        I have two tables with different granularity.

        table 1 -  field a

        table 2 - field b and field c

        The field a  value (string) in table 1 can appear in field b or field c in table 1.

         I 'm trying to do a join using something like contains or search string in field a  in any of the two fields b or c and retrieve them the information from table 2 for that record found.

         So far,  i didn't manage a way to do it in an easy way. I've seen you can inject certain join conditions and filter only certain wildcard patters but not the way to implement this logic yet.

       

      Any help will be great.

      Thanks in advance.