Hi,
I want to filter out the unique rows on the basis of two column :-
Event Date
Employee ID
But there are two conditions :-
1) If we have "Item" mentioned in created column and their is date then we have to take the row which has date in created column as unique value.
For ex :-
For employee ID 101 we have two rows for 4/20/2022 event date but we have to consider rows which has 5/9/2022 8:54 as created date.
2) If we have date for both duplicate rows then we have to take the latest date
For ex :-
For employee ID 103 we have two rows for 4/5/2022 event date we have to consider the rows which has 5/9/2022 18:00 as created date.
Thank you in advance :)
Solved! Go to Solution.
In place of unique tool you can sample tool as well. Group on Employee ID and event date and take first sample only.
Actually I got the answer we can use join tool and whatever is in right anchor is our left out data.
Thankyou @Amol_Telore