How do I combine data from 1:n relationship into 1 column in a data table

Hi there,
I have created a view that pulls data from several tables that have a 1:n relationship. For example, I have people with different roles. And they can have more than one role. When the data is retrieved then I get for example rows of data like this:

ADAM | FOH |
ADAM | CHEF |

What I want to be able to do is combine the roles so that I just get one row like:

ADAM | FOH, CHEF |

Thanks in advance.

Hi @Adam_Martin

Welcome to our community and thank you for trying out Backendless.

It is not possible to present the data in this way (using commas in a single row) in the view.
You can try using the “Group By” function and group the data by the selected column.

Regards,
Viktor