Analytics question - prompting for value

Question

Hi all

I have a workflow that we manually enter a value of either username or user ID (i.e. GUID) into a filter e.g. Contains([Worker],"Shannon Nel") or Contains([GUID],"SNEL099") and  run the workflow based on the results.

I'd like to see if there was a way that we could prompt the user to select user name or GUID, then enter in the appropriate value e.g. Contains([Worker],"value1") e.g. or Contains([GUID],"value2").

Let me know if i haven't described my query very well - any help or suggestions would be greatly appreciated.

StephenT · Answer

Hi @clmc9601

Your 'fix' is ideal, and works well. Thank you so much.

On the rare occasion we have to enter more than one GUID so I'm wondering if all I need to do this is change the text box to 'multi-line' ? And do I need any special formatting to differentiate the 2 GUIDS (e.g comma, semi-colon etc.,)

Based on your solution i have already implemented it into our process.

I will mark the solution as accepted, and liked, shortly.

clmc9601 · Answer

Hi @StephenT,

Thankfully this is a simple fix! Your action tool hasn't been configured. Action tools can be tricky to learn, but they're key to actually creating an analytic app. It's how you implement the user's changes.

The action tool needs to taking the GUID input and changing some configuration in the underlying workflow.

Here's your original non-configuration. Whatever is highlighted in blue, the action tool will try to replace with the connected interface value. Some things don't accept changes, like the tool name. That's why this is an ineffective configuration.

Here's the configuration I'd recommend (after changing your filter tool)-- note, this will only work when run as an analytic app or in Debug because none of your workers have a GUID of "test"

And I've attached the workflow as well. If this helps, please consider marking it as a solution so others may find it. Thanks!

Add Free Text Input to WorkFlow.yxwz

StephenT · Answer

I've had a look at the "Entering Free-Form Text" lesson but can't get the input free text entry to work with the filter.

I have an input file with name and GUID

I have 1 text input (may need to be converted to XLSX ?) containing name and GUID, but when i run the attached workflow

the data output is the column headings.

If someone could point me in the right direction, as to what I am doing wrong, I'd be appreciative

Alteryx Output test.xlsx

Add Free Text Input to WorkFlow.yxwz