Hi Reeza, Thanks for getting back again. I do get your point but when we are talking of the second iteration, does it not take values only from amounts? let me explain what i am thinking: 1st iteration...both same names so both contribute to the output dataset. hence C=1 and A=1 2nd iteration...not same names but the name on amounts matches the one in PDV already... so only amounts contributes to the output dataset. hence C=0 and A=1. What am I missing here and where am i going wrong. Really need to clear this.
... View more