Convert Text Input into comma separated text to then update 4 in database connection value

[cowannbell]

I have a workflow that the user selects how they want to run the report.  Either by TIN, PIN or NPI.  Depending on their selection one of three different workflows run.

Currently it is set up to just accept 1 input via a text interface tool.  That then passes through an update tool to update the text in the formula for an in database connection.

I now need to update the workflow and change the text interface tool to a multi line.  I then need to take that and convert it to comma separated to then pass through to the action tool.

I know how to convert the text list however I don't know how to pass that through to the update tool. The last part of the conversion is a summary tool and I don't know how to connect that to an update tool

Any suggestions?

[Robin_McIntosh]

Couldn't they just enter the multiple values separated by a comma?  That is then passed to your formula tool.  If you are doing an in database query, you would then change your WHERE from an equals to IN(...).

Would need a little more info.

[Robin_McIntosh]

@cowannbell - I sent you a private message as well.

[cowannbell]

No, I don't want to do that.

[Robin_McIntosh]

@cowannbell Don't want to do what?

[cowannbell]

I don't want to make the user enter each one with a comma. 

[Robin_McIntosh]

We'll touch base later but high level, here's some steps you'll need to do.

1 - Set the Text Box (interface) to Multiline
2 - Send the entries (Action) to a Text Input (single field)
3 - Use Text to Columns (Split to Rows) with delimiter of \n (can indicate comma or \s as well just in case user inputs differently)
4 - Then join back/filter to the Input or update formula, etc.