Compare 02 Large Excels

[VJ_88]

Hi ,

I need to perform comparison between 02 excels

Ideally they should have same data and same columns but as have 105 columns and 05 million records manually trying to create which should be dynamic

Kindly help us compare 02 excels, to determine each cell of 01 excel matches with other excel (2nd one/0

Any help will be appreciated if we fully automate we need to check file Alterxyx fike compared with VRPM data

[alexnajm]

Have you used the Expect Equal Tool? If you don't have 24.2, you can download the CreW macro version: CReW Expect Equal | Alteryx Marketplace

[VJ_88]

Hi @alexnajm ,

Expect Equal to tool is not what is required , suppresses all differences after 4

[alexnajm]

It might be worth then doing some corrections to the ones it lists, re running it, and getting the list down bit by bit

[Yoshiro_Fujimori]

@VJ_88 ,

Simply put, the table comparison is broken down to the comparison of the cell values of each cell position.

So you convert the two tables to the shape of ([row], [col], [value]), and compare the value for each pair of ([row], [col]).

Here is a sample workflow.

The first container is to create two tables with 1000 rows x 1000 cols, with only 1 cell is updated for test.

It should work for larger tables, but the performance depends on the memory resources, of course.

If it takes too long to run the workflow, you may need to split the table.

The second container is to compare the two tables.

If the value fields you compare are [String] fields, you may replace the expression in the filter tool as below:

REGEX_Match([Table1],[Table2],0)

(Because "=" operator cannot be used to compare strings with Case-Sensitive.)