Filtering data on multiple condition

[sgaryali]

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 :)

[Amol_Telore · Accepted solution]

I hope I have answered your question.

[Amol_Telore]

In place of unique tool you can sample tool as well. Group on Employee ID and event date and take first sample only.

[sgaryali]

I have few entries which have only Item in created date and they are unique.

If I am using filter tool they are being left how can I take them into consideration?

As I have to calculate SUM of OT hours but those entries are getting missed.

I have updated the file please check.

[sgaryali]

Actually I got the answer we can use join tool and whatever is in right anchor is our left out data.

Thankyou @Amol_Telore