Two excel data compare and write the field which matched/unmatched

Help
1

Hi, I am comparing the data of two excels sheet from the two different folder.
Scenario:- I have two different folder where I have 10 files in the folder1 and same files I have in the folder2.

I already did the comparision part and written the status in another excel if Match or Not Match against the CustName.
Here is the screenshot.
image

Now I want to write in the same excel which column data is not matched?

@Palaniyappan @HareeshMR @Shubham_Varshney @Lahiru.Fernando

2

Pardon me, can you clarify this?
Are you wanting the data which has not matched in the status column ?

1 Like
3

Bro yes, If you see I want like this output.
yellow color headers are those which I basically compare the data from the two excel.
I want to write which is match and which is not matched.
I want like this output.
image

I want like this output.

image
image746×103 3.6 KB

If you see bro, In the status is Showing Match when all fields are matched. If none of the field match the Status will be Not Matched

Hope you understand it bro :slight_smile:

2 Likes
4

use if condition ,the else part will do so.

1 Like
5

could you please explain it more bro.

6

please correct me if iam wrong,you were using loop and if condition to check wheather it is matching?

1 Like
7

Yes, but if you see bro. I put AND in the operator to check if all columns are matched then update the status Match/Not Matched.

Not if you see I added all fields which I am comparing the data now I want to write the status below if Match/Not Match

Above I attached the screenshot.

8

can you share you xml?

1 Like
9

sure bro.

10

image you can make default value as unmatched. try with this .:slightly_smiling_face:

1 Like
11

I shared you the excel file bro please find.

12

the steps you need to follow:
1.read range activity to read the excel
2.for each row
3.if condition (to check wheather it is matched or not)
please try with these steps ,you will get a solution.

1 Like
13

I didn’t use Build Data Table here

14

Main.xaml (23.5 KB)
there is an doubt in this flow.in an excel if we give sbi share,tatasteel share…it scrapes and write into excel successfully but other than share if we give anyother value in excel for search means in throws an error.without any error i need this flow to run successfully.
anybody has solution

15

share.xlsx (8.1 KB)

1 Like
16

any one has any solution