Designer analytics - prompting for multiple values

[StephenT]

Hi all

I have a workflow that I need to add a prompt for 1 of 3 values, but cannot see how this is done. I have just starting analytics apps, and using date prompts, but this one is a little complex for me (apologies).

I can prompt for 1 value (e.g. GUID) but not all 3 

The values are :

GUID (e.g. jsmith237)

OR

Email address (john.smith@dunnowhat.com)

OR 

Name (John Smith)

Also (to make things even more confusing) there will be an occasion where multiple GUIDs or email address will have to be entered. I've attached a dummy file of the fields as an example

Is what I am looking for possible with Alteryx Designer ?

[AkimasaKajitani · Accepted solution]

Hi @StephenT 

It is a little complex to realize by the Designer, but it is possible.

1.one from 3 values

This is the workflow to choose one from 3 values by using radio button that you should check the "Collapse Group When Deselected". And also, the radio button should be set if radio button is uncheck, the container is disabled by action tool.

Radio button setting :

Action tool setting connected from radio button:

2.Multiple items

You can use an IN operator to realize the multi item selection.

In this case, you need to use the expression bellow in action tool connected from Text Box tool.

'[GUID] IN ("'+Replace([#1], ",", '","')+'")'

Please refer the sample workflow(1of3value_multiinput.yxzp).

[StephenT]

Thanks @AkimasaKajitani 

This is a great solution, and i've implemented it in to my workflow

[StephenT]

Hi again @AkimasaKajitani 

I am finally checking on your 1of3value_multiunput solution however the version of Alteryx my firm used is 2019.3.1.24384. Is it possible to downgrade your Alteryx package and re-upload so i can check it out ?

BTW your other solution (radio button selection) is working very well

[AkimasaKajitani]

Hi @StephenT 

I don't have lower version of Designer, so I can't upload the yxzp of lower version.

Please refer this blog for how to downgrade of the workflow.

https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/...

[StephenT]

Thanks @AkimasaKajitani 

I managed to open the package, but noticed both packages are the same.

I've already implemented the '1of3values' package, and it's working very well. But I am not looking at the "1of3multivalues" package, and it's the same as the first package.

Am i missing something ?😁

Again, thanks for your help.

[AkimasaKajitani · Accepted solution]

Hi @StephenT 

I would like to share the yxwz version. Please check it.

The differences are the expressions of Filter tool and Action tool.

Action tool : 

Filter tool :