Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

List Tool

udayan
7 - Meteor

How to add multiple List box with a dataset?

11 REPLIES 11
atcodedog05
22 - Nova
22 - Nova

Hi @udayan 

 

You should be able to add multiple list box with dataset like below.

atcodedog05_0-1633675680066.png

 

Let me know if you face any issues.

 

Hope this helps : )

 

udayan
7 - Meteor

Suppose I want to select the "Country" & also want to select "year" simultaneously using list tool. 

atcodedog05
22 - Nova
22 - Nova

Hi @udayan 

 

Its possible. Can you provide an excel with year and an excel with the country I will help you with an example.

udayan
7 - Meteor

I attached the dataset here.

atcodedog05
22 - Nova
22 - Nova

Hi @udayan 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1633694958071.png

 

Hope this helps : )

udayan
7 - Meteor

Sorry for the late reply. You select country as "USA" and year as "2014" in the list tool but in our result we get "BRA" as a country and also "2013" as a year in our result. But I want only the selected country & selected year data.

atcodedog05
22 - Nova
22 - Nova

Hi @udayan 

 

Can you share a sample snapshot of your workflow and the result you are getting. If possible can you share a sample workflow with the issue you are facing.

 

We will be happy to help : )

udayan
7 - Meteor

I want to select "IND" from Country and "2013" as a Year so I want only the total Sales of IND in 2013. I attached all the necessary data.

atcodedog05
22 - Nova
22 - Nova

Hi @udayan 

 

2 changes

 

1. Configure List box as highlighted below

atcodedog05_0-1634019362969.png

 

2. Configure Action tool as highlighted below

atcodedog05_1-1634019420140.png

 

Workflow:

atcodedog05_2-1634019448073.png

 

Hope this helps : )

Labels
Top Solution Authors