How can we compare multiple excel files in two different folders with every row and column and update the result as first folder excel and second folder excel data is matched or not and so on comparing all excel files

Help
, ,
1

i need correct info i am new to uipath can any one help me please.

2

Hi @Ashwini_ks,

Try the approach followed in the link below…

3

hi @kantheshm
i already watched that vedio but i didn’t get correct info.

4

@Ashwini_ks
Try this activity in marketplace…

Compare Datatables - RPA Component | UiPath Marketplace

5

@kantheshm i am unable to attach my workflow

6

@Ashwini_ks
Okay no issues. Try this activity in marketplace. It solves your need…

Compare Datatables - RPA Component | UiPath Marketplace

7

@kantheshm
i have multiples of excel files,csv files and txt files in two different folders

8

@Ashwini_ks,

Here wat you can do is, you can read the file name with location of each folder. Then you can iterate through each file name in for each followed by read range and the activity shown above.

In this way you can achieve your requirement.

PS- Text file shld be treated separately…

9

Like u can use lookup datatable activitiy to lookup values from one excel in another Folder and use write cell activitiy to update values if found.

This is the logic u can try

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed::relaxed: