topic Re: How do I combine rows on common fields and add separate columns for differences in App Development

How do I combine rows on common fields and add separate columns for differences

M1ha — Wed, 05 Apr 2023 13:06:09 GMT

Hi there,

Bellow is a screenshot of a table from my app.

Is there a way to merge/combine the lines with same IDs and have the emails as separate cells like below?

I tried =Aggr(CONCAT(DISTINCT [Email ],', '), [Name]) but can't find a way to split emails list field into separate columns:

Thank you!

Re: How do I combine rows on common fields and add separate columns for differences

justISO — Wed, 05 Apr 2023 13:23:11 GMT

Hi, I believe you need to create separate columns to have values in each of them, you can create one and show only 'first' email in it with something like this:

SubField( Aggr(CONCAT(DISTINCT Email,','), Name), ',',1)

You can create second column and show only 'second' email etc.:

SubField( Aggr(CONCAT(DISTINCT Email,','), Name), ',',2)