4 Replies Latest reply on Feb 28, 2017 4:55 AM by shashank.sastry

    Joining id of table 1  to other id(which is comma seperated value) of table 2


      I have a requirement which is like this


      table 1                                                        


      ID                name

      1                  john    

      2                  sam

      3                  nick


      table 2


      ID              PRODUCTS PURCHASED

      1,2            IPHONE

      1,2,3         IPAD

      3,2            MACBOOK


      Any customer can have multiple product purchases.


      I can't join these tables as ID of table has comma separated values data,so is there any way I can convert ID of table 2 into normal rows with single ID value and then join that with table 1 to get customer info.Can this be done from tableau side instead of DB?