Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Filter the rows after a key value

Ekta
8 - Asteroid

Hello everyone, 

My dataset is something this - 

Input -                                               

Record id iddate
11 
21 
3107/11/2020
41 
52 
6204/10/2020
72 
83 
93 
10309/06/2020
113 
123 
133 

 

I would like to filter the output to only get rows after the date, so my outputs looks like below

Output 

Record id iddate
41 
72 
113 
123 
133 

Please help me with this, Thank you  

3 REPLIES 3
messi007
15 - Aurora
15 - Aurora

@Ekta,

 

Please see below :

 

messi007_0-1634816795439.png

 

What I don't understand on your expected output you get record ids 12 and 13 ?

 

Attached the workflow,

Regards

PatForData
8 - Asteroid

Hi @Ekta 

If you want to keep 12 and 13, I suggest you use two multi-row formulas to create an indicator to filter on.

 

Please see attached.

 

Many thanks

PatForData_0-1634817248368.png

 

Ekta
8 - Asteroid

@PatForData Thanks so much for your solution

Labels