How to Filter Excel Data based of "Employee ID"

Help Studio
1

Hi
I want to filter and get the record based Employee ID.

image
image1129×248 7.58 KB

Any suggestion Please?

Kind regards
-Vincent

2

Hi @Vincent_Nuestro

You Can use filter datatable or select method!

Dt.Select(“[Employee ID] =‘youfilterempId’”).CopyToDataTable

Refer the link below.

Regards

1 Like
3

Hi, the Employee ID is a dynamic data, it Always change

4

Hi @Vincent_Nuestro

Read range the Dt

For Each row in Dt

Assign—> FilterDt= Dt.Select(“[Employee ID]='”+currentRow(“Employee ID”).toString+“'”).Copy to Datatable

With in the Body Write Range With the Path “Yourpath”+currentRow(“Employee ID”).toString+“.xlsx”

Datatable—>FilterDt

Regards

5

Hi @pravin_calvin its not working sir,

6

hi @Vincent_Nuestro

If Its possible can you share me your file here?

Regards

7

Hi @pravin_calvin

Please check sir
TESTFILTER.zip (17.2 KB)

8

Hi @Vincent_Nuestro

I need clarification, Do you need each employee id as each excel file right?

Regards

9

Hi @pravin_calvin

I need all the data of each employee Number,
if Employee ID has Duplicate, I need to get all the data Under 1 Employee ID.

EX: we filter Employee ID “168076”
it will show 2 Records, then i need to Copy all those data under “168076”.

10

Hi @Vincent_Nuestro

Please Check with the below zip file.

Hope the below helps you!

TESTFILTER.zip (24.5 KB)

Regards

1 Like
11

I worked Sir @pravin_calvin

thank you for your Help

12

@Vincent_Nuestro

Don’t Mention sir Cheers!

Happy automation buddy!

Regards
Calvin

1 Like
13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.