In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Filter certain rows

Kallis
8 - Asteroid

Hi

I have a requirement based on which I need to remove certain rows from the final output. From the below table, I need to leave out all those cost elements that starts with 5 and pick the ones that starts with 6.

 

I do not know whether this can be achieved using the Filter Tool. Kindly help

 

Cost ElementPosting DateTest 1
52032324-06-2024Test
52032324-06-2024test
52032324-06-2024Test
52032324-06-2024Test
52032324-06-2024Test
52032324-06-2024Test
52032324-06-2024Test
52032324-06-2024Test
60202412-06-2024t
60202412-06-2024t
60202428-06-2024t
60202428-06-2024t
60202412-06-2024 
60202428-06-2024 
5 REPLIES 5
alexnajm
18 - Pollux
18 - Pollux

A StartsWith function in a filter tool should work well for your use case

alexnajm
18 - Pollux
18 - Pollux

StartsWith([Cost Element], “6”)

Kallis
8 - Asteroid

@alexnajm I thought about such a parameter but it is not there

Kallis
8 - Asteroid

Sorry @alexnajm 

You meant a function. I just saw that

Kallis
8 - Asteroid

Thanks @alexnajm 

It works. I will mark this as solution

Labels
Top Solution Authors