Checking Database

Hi!!!

i have two SQL data files which has same fields same data if it has any mismatching data(some missing data or different data) in that fields then I want to store mismatching data in another field β€œis it is possible to store the data in different field? :thinking:” if it is possible then how i do it? please give me a solution in some steps!!!

Regards,
Thilagavathi

Simple way to do this to iterate both the tables one side the other check all column if match dont do anything if not then update that row using Build data table.

1 Like

Thank You!!! for your reply and i have doubt in iterating that two tables please give me any reference for that activity

Regards

Thilagavathi

Use a for loop in which use Outer datatable,
Use one more for loop inside the above and use If condition inside for the inner for loop.