Hi, I am trying to do this.. and I noticed that Lookups fetch all the rows...I want it to fetch value based on value passed into main input.

eg,

Example

source1
id col1  col2 col3
1 aaa             
2 bac             sds
3 232   2za   d54

Source2
id col1  col2 col3
1 bac             bcc
1 232   zxz    bcc
2 asa   rd3    43d
3 sss   dsd    de2

lookup after the first pass( this is bascally the output after the input that is commited for the previous record)
id  col1 col2  col2
1 aaa             

lookup after the second pass( this is bascally the output after the input that is commited for the previous record)
id  col1 col2  col2
1 aaa             bcc

lookup after the third pass( this is bascally the output after the input that is commited for the previous record)
id  col1 col2  col2
1 aaa    zxz    bcc
2 bac    rd3    sds



My end result should look like

target table
id  col1 col2  col2
1 aaa    zxz     bcc
2 bac    rd3     sds
3 232   2za    d54

Notice the Ex:  My intent is to update the records with columns that have null value in the records that was previous commited.