How can I easily improve the comparison between 2 xlsx files (or 1 xlsx with 1 csv) considering that it is a recurring task where data is updated everyday. File 1 = Authorized transactions File 2 = Invoiced transactions [STRU] Problem is that data is not always presented in the same way :face_with_raised_eyebrow: I would like to identify quickly: 1/ the transactions that are OK 2/ missing transactions 3/ incorrect transactions Any advice? Thanks :slightly_smiling_face:

use a groupby node to sum up the prices and then join the data and check whether difference is 0 (e.g. math formula node) if it is → works if it is not → not OK if there is no join mathc → missing br

Comparing 2 xlsx files

KNIME Analytics Platform

gonhaddock March 21, 2024, 9:57am 7

Hello @carlos_LOGO , and welcome to the KNIME community.

Please take a look to the following post solution; this is for a similar use case to the one in your challenge.

Let me know about any further clarifications if needed.

2 Likes