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'.
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.