List Tool

[udayan]

I have a dataset. It has 5 distinct year (data type is double) & want to extract data using the year. I want to extract data using the list tool. When I select any year it show me an error. I attached my workflow and the error. I will be grateful if anyone give me a solution or if the solution already given then kindly give me the link.

[atcodedog05]

Hi @udayan 

Here is how you can do it.

Configure filter tool like below to allow list of years

Configure List Box tool like below

Configure action tool like below

Workflow:

Hope this helps : )

[udayan]

I got your point but my dataset already have a column "mvemodyr7" where all the year value like 2013,2014,2015, 2016 & 2017 are given and I extracted the unique year value using my data_1 and saving that value into another file named as trial4. I don't want to put the year value manually because for this data_1 number of unique year value is little (only 5 values) in amount but if the amount is large then it is very difficult. I attached my settings also the dataset which is feed in the tool.

[atcodedog05 · Accepted solution]

Hi @udayan 

That would also work here is the updated workflow.

Hope this helps : )

[udayan]

Thanks a lot. I really appreciate your work. I have one small small doubt that I add below.  I want to know why we have to configure the tool box like this. I understand the rest of the things. 

[Jonathan-Sherman · Accepted solution]

Hi @udayan,

Because it's a list box you may select more than one value (i.e 2017 and 2019). Alteryx needs to know how to deal with multiple values, in this case it generates a custom list concatenating the values with a comma between:

2017,2019

Therefore when it goes into the IN() function you keep records that are 2017 or 2019.

Kind regards,

Jonathan

[atcodedog05]

Hi @udayan 

Another point to add is

Numeric list goes like this (2017,2018)

String list goes like this ("2017","2018")

Based on your requirement you need to set the options