Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
orangebloss
Contributor III
Contributor III

Concatenating data in table in App

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
Labels (2)
2 Solutions

Accepted Solutions
Clement15
Creator III
Creator III

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

Clement15_0-1710238677985.pngClement15_1-1710238689329.png

 

View solution in original post

Clement15
Creator III
Creator III

Yes, you can use same formula in one measure

Clement15_0-1710251113279.png

 

View solution in original post

4 Replies
Clement15
Creator III
Creator III

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

Clement15_0-1710238677985.pngClement15_1-1710238689329.png

 

orangebloss
Contributor III
Contributor III
Author

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
Creator III
Creator III

Yes, you can use same formula in one measure

Clement15_0-1710251113279.png

 

orangebloss
Contributor III
Contributor III
Author

Brilliant thank you!