Logic needed for this scenario

[cbhutani2]

Hi,
Can someone tell me logic for this scenario:
From the left link, records are coming in this way:

col1 col2 col3 col4 col5 col6 PK
a null b c null d V1
null b d e f null V2
v null f null d h V3
b J C null s a V4

Now, what I have to do is, for each record, take all fields which are not null and update them for the same fields of some other record in the same table. How can I do this.

i.e. for all fields of suppose V2, which are not null, update the values wherever V2 is not null in V1.

This is urgent.can someone pls guide, since, If I compare with field names to be not null, the same field name can be null for one row and have value for another record..how do i build this logic in datastage, which stages can i use etc?

regards,
Sumati.

[ray.wurlod]

I am certain that this exact question has been answered recently. How about you Search for it?

[chulett]

And while you're searching, let us know what this 'other record' is exactly, how you will derive the key value for the Lookup.