Concatenating data in table in App

[orangebloss]

I have a list of Tasks, each loaded with potentially multiple 'Tags'. When I build a table in the app it brings back separate lines for each 'tag'. How do I combine these into one field?

Task1	Blue
Task1	Yellow
Task2	Green

Desired outcome

Task1	Blue,Yellow
Task2	Green

[Clement15 · Accepted solution]

Hello, this is an example of how to do this.

[orangebloss]

If I wasn't to do this in the load script is there a way to do it in the table itself?  I need to keep the tasks separate for other reports in the dashboard so don't want to lose that data?

[Clement15 · Accepted solution]

Yes, you can use same formula in one measure

[orangebloss]

Brilliant thank you!