Hello everyone,
My dataset is something this -
Input -
Record id | id | date |
1 | 1 | |
2 | 1 | |
3 | 1 | 07/11/2020 |
4 | 1 | |
5 | 2 | |
6 | 2 | 04/10/2020 |
7 | 2 | |
8 | 3 | |
9 | 3 | |
10 | 3 | 09/06/2020 |
11 | 3 | |
12 | 3 | |
13 | 3 |
I would like to filter the output to only get rows after the date, so my outputs looks like below
Output
Record id | id | date |
4 | 1 | |
7 | 2 | |
11 | 3 | |
12 | 3 | |
13 | 3 |
Please help me with this, Thank you
Solved! Go to Solution.
Please see below :
What I don't understand on your expected output you get record ids 12 and 13 ?
Attached the workflow,
Regards
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 Thanks so much for your solution