How to get unique values

Help Studio
1

I would like to extract the data from the last tab of ‘Staff List-Test’ where only the people who have ‘Y’ under the participated column to become the output that would look like ‘Summary’, where the departments are separated into different excel sheets

Please help!!

Staff List - Test.zip (11.9 KB) Summary.zip (9.9 KB)

2

@foppishinc

Use filter data table activity. Refer below.

In Column name pass “Participated?” and in value pass “Y” and keep operation equal.

image

https://docs.uipath.com/activities/docs/filter-data-table

3

@Pravin_Patil1 I have done up a sequence with the filter data table but the output that I wanted should be looking like this where the different departments are separated into different sheets
Sequence1.zip (1.4 KB)

image
image566×788 14.8 KB