General Discussions

Discuss any topics that are not product-specific here.

Compare two spreadsheets of different layouts and return mismatched values

Srini96
8 - Asteroid

I have a grid which has rates in excel and the second set of data is pulled form SQL which is the import file manually created from the grid.

Is there any way I can compare the grid with SQL results without manually mapping the two?

 

 

Note: The results are being pulled into an excel sheet. 

1 REPLY 1
AbhilashR
15 - Aurora
15 - Aurora

Hi @Srini96, just to confirm, you are looking to compare rates value coming from two different datasets? If yes, then I suggest bringing them together in a join tool and looking at the L-J-R outputs to see which ones matched, and which ones did not.

Labels