Copy values from one column in one excel and search in another excel

hi all,
i have two excels basically data excel and student excel.
1.basically in data.xlsx i have one “user id” that i need to copy
2.search that copied id in student excel in column “StudentId”
if userid data is match to the studentid then it will print that id else will send mail that id is not present in student exce.

i tried for each in side for each and in if i used row1(“user ID”).tostring=row2(“StudentId”).tostring which is workin fine but problem is in student excel i have lot of data and row by row it is checking which is not good.so do we have any filter data table or other option so that i will copy id and only that id will search in student excel.and if in filter not present send mail

1 Like

Hey @Sayali_Rokade1

Kindly use the Filter data table activity and pass the user id column name and value in the filter condition.

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

Linq queries is an other option, but tough to handle as a beginner.

Hope this helps

Thanks
#nK

@Nithinkrishna can you please explain me the flow for abv.i tried but i am confused that how do i take two excel and filter using row(“”).tostring

1 Like

Hey @Sayali_Rokade1

Is it possible for you to provide the excel with sample data…

Will be better to provide a demo.

Thanks
#nK

@Nithinkrishna will share you screen



shots

1 Like

Hey @Sayali_Rokade1

Please find the below demo…

nmnithinkrishna_CompareStudentTables.zip (14.3 KB)

Hope this helps…

Thanks
#nK

@Nithinkrishna thanks for your efforts ,will check your flow

1 Like

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