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
in csv i have
now how can i blend these two datasources to get the below view
Hi Maddy -
You're not going to be able to blend these based on the current shape of the data in your CSV. I suspect you already knew this and were hoping there might be a "trick" to make it work - but in this case you'll need to do something to split out the ID values into distinct rows.