1 Reply Latest reply on Jun 25, 2012 2:36 PM by Tracy Rodgers

    Join two tables as "CONTAINS"

    Serge GABRIEL

      Hello,

       

      I have one problem joining two data sources.

      Pease find more details and an example on the attached file.

       

      Sheet Tasks

      How can I join 2 tables so that an item called "Supplier 1, Supplier 2, Supplier 3" in a first table refers to the item "Supplier 1", "Supplier 2", Supplier 3" in the second table?

      I tried to do it with CustomSQL and the function "LIKE" but it doesn't work...

      I would like to say that it creates a joint when one field "contains" the other...

      Look at the example to better understand it.

       

      Thanks for your help!