Export columns from repeated joined table

[lcollong]

Hi,

I've a table joined to another one (addresses) which is repeated. Thus I have several records in the joined table for one master record. Using the export give the possibility to include columns from the joined table. But the result is a cell filled with a json like syntax. Ie for city, I have : ["Paris","Ivry sur Seine","Meaux Cedex"].

Is there is a way to have each column value in a different cell ? I would have expected the columns of the master table followed by the columns of the first joined record, followed by the ones of the second joined record, etc...

 

[rob]

hi Jerome
That's not possible with the code we currently have. CSV isn't really designed to deal with relational data, so doubling up lines isn't really going to work well in a lot of situations.

 

[lcollong]

Thanks Rob. I'll see if I can create a dedicated view or I'll write a php script to create a special file.