community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

regarding filter for text rows

Asteroid

hello,

 

I need to filter a set of text rows among many text rows. But not based on record id.

1school
2office
3administration
4pantry
5terrace
6development
7design
8function
9tool
10software

 

the below table shows an example that I need to filter. so here, I need to filter between terrace and tool based on the strings of the rows. as I tried and I can only filtered one row either terrace r tool but not in between rows.

Apologize me if I questioned anything wrong. Just to know, is this type of filtering is possible or not?

 

5terrace
6development
7design
8function
9tool

 

 

Thanks,

Thulasi S

Alteryx Certified Partner

Solution attached.

Asteroid

hii @ryan_lambert,

 Awesome!!!! that works perfectly, thanks for your response.

 

Thanks

Thulasi S

Asteroid

Hi @ryan_lambert,

 

I am pretty much happy with the previous solution u gave for my problem. But, I need a little modification in that, what if I have a same  set of rows following the previous set of rows. I need to filter it as follows.

 

1school
2office
3administration
4pantry
5terrace
6development
7design
8function
9tool
10

software

11

ABC

12DM
13school
14office
15administration
16pantry
17terrace
18development
19design
20function
21tool
22software

 

the resultant should be

 

5terrace
6development
7design
8function
9tool
17terrace
18development
19design
20function
21tool

 

so the middle unnecessary values should be filtered and same set of values in the same field is to be filtered. Give some idea on this.

 

Thanks and Regards,

Thulasi S

Highlighted
Alteryx Certified Partner

Hi @Thulasi

 

Take a look at my workflow. Filter tool is enough to solve your problem. Hope it helps.

 

Filter.PNG

Asteroid

Hi @haroon_sa 

Thank You Very much for the solution. It works for me.

Labels