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
