Create interface tool for search and filter

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.

Capture.PNG

Interface Tools

Accepted answers

All comments

binu_acs

@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.

0813-Aaditya Singh.png

0813-Aaditya Singh.yxwz

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.

Capture.PNG

Qiu

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

0813-Aaditya Singh-r1.png

0813-Aaditya Singh-r1.yxwz

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?

apathetichell

if there's just a single selection - the advantage would be you could have 3 groups (a-h,i-p,q-z) or something - and then drill by last name - but yeah - I assumed this was a drill 1/select from second level project.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703