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
Use the concatenate option in a summarize tool
As @SPetrie mentioned, Summarize tool can do the trick.
In Summarize tool configuration, select the field you want to concatenate and choose [String] - [Concatenate]
Summarize tool cofiguration
You can also configure the separator (default is comma as below.)
Input
Output
For further details, you may want to check Interactive Lesson : Summarizing Data especially Section [Action Properties]
Good luck.
@DavidKennedy
Some good replies are there already but I still want to give mine if I can.
I add one space after the comma for the seperator so it looks more like a sentance as a header.
And I replace the last comma and Space to space+and+ space to be exact as you requested.