Hello again everyone,
I commonly have to suppress data from certain plants while they are undergoing system maintenance, implementation, etc. I have to document which plants' data has been suppressed from the reports generated. Its easy enough for me to list the plants in a column but I need a way to join the records in that column so I can have them as a single text string (separated by commas) that I can add to the header of a report. The issue is the number of plants varies from report period to report period. Below is an example of what I'm working with and what I need.
Here's an example of list of plants for which I suppressed their data.
I need to have a single string that would read as "Springfield, Quahog, Eternia, Narnia, and Risa" which I could then use downstream as a header for a report.
I also need this to be dynamic in that it "knows" how many plants (records) there are and can automatically adjust the list length accordingly.
For example, one week the list would read as above but the next week it might only have 3 plants as below.
For this one I'd need the list to be "Springfield, Narnia, and Risa".
Any help will be greatly appreciated.
Thanks,
David
