Custom Filter - how to properly filter data?

Question

Hello All,

I'm having trouble creating the right filter in my workflow.

For some workers, I have double entries and I want each worker to have only one entry. As you can see, there is data for some employees and not for some. I want employees without data to also be included in the final data set.

I would be very grateful for help.

Data.png

Data set.xlsx

aatalai · Answer

Also @a_sulkowska you could use the unique tool

Amit_G_Limbasia · Answer

Dear @a_sulkowska

If you can say condition what you want accordingly we can manage the filter to get value

If you data is proper and you just need first value from each then create a column of record ID based on group by by worker and then in filter select record ID 1 you get your desired output!

Please find the Example for the Solution

Amit_Solution.yxmd