Forum Discussion

manohar's avatar
manohar
Contributor
5 years ago

To check if matching records have different value in other column

Hi there, I have 2 excels fiels, source and destination. each one has 3 columns, Id, Quantity, last modified date. I need to find if there’s a matching record by Id but has different values in Qua...
pipeline
sample_pipeline
bojanvelevski's avatar
bojanvelevski
Valued Contributor
5 years ago
Copy Link

You can work on some logic here. If you add “last_modified” as a sorting path, along with the “id”, you’ll get the following scenarios:

  1. When id is matched, last_modified is the same, and quantity differs, you’ll get the modified record in “Modified” output.
  2. When id is matched, last_modified differs, and quantity is the same, you’ll get the result from source as a “Deletion” and data from Destination as a “Insertion”

From there you can arrange the flow per your needs.

I hope you’ll find this helpful,
Regards,
Bojan