Select from drop down

I cannot see your drop down list. Please check on your own and make sure it follows this:

That should do it.

@Thiviya If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

All comments

You mean you want to make it into an Analytic App? The drop-down selection comes from having the user selecting it?

H, Yes wanted user to select the relevant category when the reconciliation is prepared. How do I do that?

Regards

Thiviya

Here's some reading material:

Drop down selection update to two accounts.PNG

Hi,

I have created the drop down and action tool. I have connected to Filter tool However how do I choose more than one from drop down. Also how do I update if there are two accounts under one category.

Thanks

Regards

Thiviya

ITR Rec workflow drop down.yxmd

ITR Rec workflow.yxmd

I've attached an example for you to learn.

To select multiple, you need a List Box interface tool rather than a Drop Down interface tool.

Make sure to change your Filter tool's expression accordingly to have a statement like:

[YourFieldHere] IN ("ToReplace")

Then the action tool should configure to:

For further reading:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Filter-for-multiple-values-Analytic-App/td-p/1102330
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-Allow-Dynamic-Multi-select-on-a-List-box/td-p/517762
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Multiple-selection-in-Drop-down/td-p/615154
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Analytic-App-Select-Tool-How-to-use-list-box-to-select-fields/td-p/1101663

ExampleForThiviya.yxzp

Thanks for the example, that is really helpful. I have updated to the list book instead of drop box. However, it is not producing any results.

I have also try your example workflow and try to select different state and no results is coming up though...

List box selecting relevant account.PNG

ITR Rec workflow.yxmd

That's because of this:

Your reference file must only have two fields: NAME and VALUE

Since you didn't export your package over, do you mind exporting your Alteryx workflow?

To export a workflow go to: Options > Export Workflow. Kindly do NOT send a "Save As" copy. Please also export C:\Users\PATHMT\OneDrive - Pacific National\ITR\Alteryx\ITR_FS mapping drop down.yxdb

Here you go exported workflow and file :

I have attached the drop down list file exported too,

If you can show me an example what to do that would be great .

Thanks

ITR Rec workflow drop down.yxmd

It works.

@Thiviya If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/

ITR Rec workflow drop down.yxzp

Hi ,

Thank you for looking into this. Really appreciated. The results you have got is what I needed. But why am I not getting the output results?

Can you please check my workflow and let me know why?

In the List box did you create the " custom list" of the dropdown list ? why both Name and Value are the same details?

I think the issue for me is the dropdown list?

Thanks

Regards

Thiviya

I cannot see your drop down list. Please check on your own and make sure it follows this:

That should do it.

@Thiviya If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

Thanks again for your time. I should close the drop-down file before doing the testing and it is working.

HI, Any reason why it is not working now ?

Capture_list box.JPG

Capture_ update value.JPG

ITR Rec workflow drop down.yxzp