topic Re: How to compare the two excel sheet like github file changes in Qlik Automate

How to compare the two excel sheet like github file changes

Jasfos — Wed, 27 Apr 2022 14:51:09 GMT

Hi,

I have two excel file. I need to compare the two excel sheet for row and column wise like the Github file changes.

Ex: Added rows, added column as same as modified row and column, deleted rows and column

file1.xlsx

A, B, C

1, Apple, 20

2, Vivo, 15

file2.xlsx

A, B, C

1, Apple,10

3, Oppo, 20

4, Samsung, 80

Lisa_Sun — Thu, 28 Apr 2022 04:34:33 GMT

There are many ways to compare the difference between two excel files and worksheets. Hope it helps.