I have one problem joining two data sources.
Pease find more details and an example on the attached file.
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!
Have you looked into data blending? The following links provide further information:
Hope this helps a bit!