Prevent error when compare two excel file that has same content

Help
, , ,
1

Hi All RPA Master

I created program to compare two excel files, I done with it.
but problem arise when two excel files has same contain (No Gap),
could i know how to handle it?

please kindly to help.

2

@zonda_rugmiaga

Sorry i didn’t get you. Could you please tell more details about the issue for better understanding.

3

@lakshman

I compare download data with master user.
if download data have new data, it will insert to master user.
if download data and master user has same data, it should only send messsage “no new data”.
but currently if download data and master user has same data, it is error.

sample of download data and master user are attached

DownloadData.xlsx (15.0 KB) Master User.xlsx (15.0 KB)

4

How are you comparing two Data Table?

5

@MartianxSpace

this is my xaml to compare two data table
CompareData.xaml (9.0 KB)