1 Reply Latest reply on Sep 17, 2012 6:25 AM by Russell Christopher

    JOIN\ Blend multiple datasources

    Rohith Reddy

      Hi,

       

      I have a datasorce(mysql) where i get two columns id and name, there is another tab delimited csv datasource where i have a comma seperated ids as one column.

      eg: in mysql i have

      1 , a

      2,b

      3,c

      4,d

      5,e

       

      in csv i have

       

      1,4,5

      1,2

      3,5

       

      now how can i blend these two datasources to get the below view

       

      1,4,5   a,d,e

      1,2      a,b

      3,5     c,e