I need to run a portion of my workflow that results in a set of store numbers (one row per store number) and then transform those rows into a text string that contains each store number separated by commas. I will then use that text string with a dynamic input tool to modify the where clause in an SQL query that accesses an table of transaction data in a table in our Oracle database. For example, the first part might return a result of 5 rows, each row containing a single store number, 1 through 5. The next part of the workflow needs to create the single text string "1,2,3,4,5" . The number of store numbers in the text string will be different each time I run the workflow.
