I've been working on this for hours and I think I'm getting further away from solving it...
I want to do a ForAll and loop through each Report by Name in the Table VAReportListings and add a column to a collection that is a concatenated list of the TagID.Name value from VAReportTags. It's a zero-to-many relationships.
So for example:
Airline Analysis, Air-Trip-Events
Arrivals & Departures, Air
Bookers & Travelers, blank currently
etc...
The ListID and the TagID in VAReportTags are lookup columns in CDS and is displaying below the "name" value.
Table VAReportTags
Table VAReportListings
User | Count |
---|---|
179 | |
119 | |
87 | |
44 | |
41 |
User | Count |
---|---|
245 | |
156 | |
127 | |
77 | |
73 |