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

Hey @manohar,

You can try and use the Diff snap for this purpose.

Regards,
Bojan

  • manohar's avatar
    manohar
    Contributor
    5 years ago
    Copy Link

    Hi @bojanvelevski , I was able to see how diff snap works. in my case there’s a scenario where Quantity is not changed but Last Modified Date is changed. how can I filter the one where Quantity is the modified one?

    Also I need to compare 2 other files where the original file has another Id column called External Id. I need to apply similar logic plus need to pull in the External Id from the Original File.

    Any directions?

    thanks
    Manohar