Hello,

Thanks for your response,

I tried to coalesce both fields A and B but field C data is not imported correctly. Here I have no other option rather than checking the combination of A & B.

In target table records as below:

Record1: India & Bangalore, C is empty

Record2: India & Hyderabad, C is empty

Source table:

Record1: India, Hyderabad, StreetNo1

Street No1 has to be updated in Target table Record2 and Record1 should be left alone.

I don't want new records to be created in the Target table if there are extra records in source table. Need just "update"

As you asked for the names, you can give anything like

Source table:

u_country, u_city & u_street

Target table:

u_country, u_city & u_street

Thanks,

Ksnow