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.