Create interface tool for search and filter

[Aaditya Singh]

Hi all,

Hope you're all well.

I wanted to understand it it possible to create an interface tool which searches and then filters data according to it. I want to create a tool which is able to replicate the same process as excel uses for column filtration. PFA the screenshot of excel to give an over view.

[binuacs]

@Aaditya Singh I don't think search and selection option available in Alteryx similar to excel filter tool

[Qiu]

@Aaditya Singh 
Try to look at the Analytic App option.

[Aaditya Singh]

Thank you for quick response.

[Aaditya Singh]

Thank you @QIU. Any idea how can we integrate it in the Analytic app. As I'm currently able to create a drop down of the list of the Names and then manually tick mark and select. However, what I want is for the user to be able to have a search bar and they are able to search through the list of name and that name pops up in the list.

[Qiu]

@Aaditya Singh 

A quick sample is as below.

[Aaditya Singh]

Thank you so much for quick turn around @QIU . This certainly helps. However, I was also looking for a search bar  as well at the top where in the user can enter a name and it will filter out in the below list. As I have a dataset for 100s of names in a list and it becomes really difficult for the user to search through the entire list manually.

 

[Qiu]

@Aaditya Singh 
We can use the Text Box but it will only allow one single line input with partial match with case insensitive.

[apathetichell]

Tree tool. @Qiu - take a look. If you haven't played with it - it's awesome. Parsing output from it is a bit more complicated. 

[Qiu]

@apathetichell 
You are properly right.
But in my understanding Tree Tool is for Hierarchical data, and it seems that in this case, the user only want to filter the user info?