Analytic App: Text Box not updating Text Input

[liztarnold]

I have a workflow that is used to check multiple inputs with multiple items against a dataset.  The workflow has three Text Inputs where the user can enter any number of codes to be checked.  My workflow runs fine as a Standard Workflow, but I want to turn it into an analytic app and run it from the Gallery.  I have tried many configurations to but have failed to get this to work.  I've attached a sample of my latest try.  I know I could use a File Browse tool, but would prefer that the user not need to create files for the input data.  Also, I do not want to use a Drop Down because the lists would be too long.  Any ideas?

[Bren_Spill]

@liztarnold - Will this way work for you? Use the interface to update a filter down the incoming list of all Sold To #s. 

User would have to enter the numbers with a comma between them in the Text Input tool

[liztarnold]

@Bren_Spill - Thank you.  This is an improvement over needing to create files, but it still requires an extra step to format the lists with ", ".  Here's an example of one of the requests.  It would be simpler if the user could copy the Customer Numbers in the 1st column and paste them into the input box of the Text Box tool. This is how it works with the standard workflow.

Customer Number	Company Code	Sales organization	Distribution channel	Division
KUNNR	BUKRS	VKORG	VTWEG	SPART
55572571	2350	F250	10	2
55672546	2350	F250	10	2
55346796	2350	F250	10	2
55224239	2350	F250	10	2
55176987	2350	F250	10	2

[Bren_Spill]

@liztarnold - another approach attached using the List Box. User can check off what they want. You can populate the List Box tool with all possible codes, or just the ones that are in the input as shown in the attached.

[patrick_digan]

@liztarnold I think the attached should get you started. The text input will just have one row, and the action tool is putting the text box into that row. The user will enter 1 item per line, so we can use the newline character in the text to columns to split the data out into 1 row per item. Then a select tool to change it back to a number if the users are only entering numbers.

[liztarnold]

Thanks, Patrick.  Your solution does exactly what I wanted.