Hi,
I have 4 fields from source those are
fac
pol
end
comm
if fac,pol,end is same then I have to append the comm to existing comm, without creating new record.
Thanks in advance.
Appending data to the exising record
Moderators: chulett, rschirm, roy
Hi thanks for you reply I am doing the same
I am taking the source file and doing the lookup with 3 key cols(fac,pol,end) and comparing those 3 keys if same then append.
It is appending correctly, but it is creating one more record and appending the data.
EX: out put is showing as follows, insted of second row , it showing first row as well.
999, 1991, 10, Hi
999, 1991, 10, Hi How r u
I am taking the source file and doing the lookup with 3 key cols(fac,pol,end) and comparing those 3 keys if same then append.
It is appending correctly, but it is creating one more record and appending the data.
EX: out put is showing as follows, insted of second row , it showing first row as well.
999, 1991, 10, Hi
999, 1991, 10, Hi How r u