This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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