Hi parvez.shaikh19,
If there is a unique key in the excel and the SQL server table the easiest way to detect changes is using Diff snap (https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438546/Diff). If that doesn’t help than you need to manually create logic for getting the rows from the excel and searching the row in the table. In order to make the search easier and faster you can hash each row (Digest.md5(col1+col2)) from the excel and do the same thing with the table rows and compare hashes instead of columns.
Regards,
Petar
@fmdf I made a video awhile ago that may help you but it isn’t published yet. I’ll reach out to you directly with the link and work to get it published for the broader audience.
