How comapare DB and excel add the row not available in DB and available in excel

im doing a DB insertion from a excel sheet i need to check the row that are in excel but not in DB and add those row to db as well.

Does your Excel and DB have an unique column like DocNo or EmpNo?

hi @monsieurrahul
their no one unique column

Can you share a screenshot of your Excel, if possible?


plz find excel attachment

Alright, in this case, you can iterate through the Excel DT using For Each Row, get the required row and check if this exists in the DB DT and in the else condition, you can add it to the DB DT using Add Data Row.

Check this:

1 Like