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.
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
Also @a_sulkowska you could use the unique tool