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

    shashank.sastry

      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?