Hi all, I have a data in two sheets both sheets have different data…how to compare both sheets and find out the difference??
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
@Palaniyappan, Can we compare two PDF or Text file as well and find out differences?
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
@Palaniyappan Thanks alot.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.