Appending data to the exising record

deva · Post by **deva** » Wed Oct 01, 2008 7:23 am

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.

chulett · Post by **chulett** » Wed Oct 01, 2008 7:29 am

Put your source keys into a work table if not already there. Join to existing keys and build a hashed file. Reference lookup drives update v. insert and gives the 'old' value to append to for the updates.

Pretty standard stuff.

deva · Post by **deva** » Wed Oct 01, 2008 7:56 am

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

chulett · Post by **chulett** » Wed Oct 01, 2008 8:05 am

What's your target? Update action?

deva · Post by **deva** » Wed Oct 01, 2008 8:09 am

I am writing into file.

chulett · Post by **chulett** » Wed Oct 01, 2008 8:19 am

I don't see how that would happen. Post the details of your job design including constraints, stage variables, etc. As much detail as you can stand to document.