Dynamically create string from Listbox to pass to Dynamic Input query

[BB]

How do I create a string from the Name values selected from a List Box? My data would look something like this -

Customer         ID

ABC                 0001

ABC                 0002

DEF                 0003

XYZ                 0004

XYZ                 0005

XYZ                 0006

Based on the Customer/s selected by the user, I will have to create a string of ID values to be replaced in a dynamic query. For example, if ABC and DEF is selected by user, the string should be '0001', '0002', '0003'.

[Robin_McIntosh]

Here's an example based on filtering a Text Input File.  Process would be similar with the Dynamic Input tool.

Within the Listbox configuration, you'll want to select the Generate Custom List radio button, this will create the string of selections (i.e. 'ABC','GHI').  This will then be passed/used within the next tool.  So here in the filter, I have a "placeholder" of XX then the action replaces the 'XX' string with the concatenated selected results.  Would be a similar process with the Dynamic Input tool where you'll need to have a placeholder to be replaced.

Hopefully this gives you something to follow along with.