Compare data from two databases

Hi all, I have a data in two sheets both sheets have different data…how to compare both sheets and find out the difference??

1 Like

Hi
We can use JOIN DATATABLE Activity and mention the method of join them we want
—use excel application scope and and pass the file path as input
—use a read range and mention the first sheetname as input and get the datatable as dt1
—use another read range and mention the second sheet name as input and get the datatable named dt2
—now pass these two Datatable to join datatable

Cheers @Rajnish

1 Like

@Palaniyappan, Can we compare two PDF or Text file as well and find out differences?

1 Like

Yah once we read the text file with read text or word document with word application scope we can compare them with string manipulation
But it’s based on the file and it’s content
Cheers @Rajnish

1 Like

@Palaniyappan Thanks alot.

1 Like

No worries
Cheers @Rajnish

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