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.
Hello @buddy_jones ,
This example shows you how using the summarize tool you can concatenate the stores. The first summarize makes sure that there are no names duplicated and the second one concatenates them.
Regards
User | Count |
---|---|
107 | |
82 | |
70 | |
54 | |
40 |