4 Replies Latest reply on Aug 7, 2019 9:04 AM by Maggie Chandler

    Join two tables as "CONTAINS"

    Serge GABRIEL



      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!