DSXchange

I use a merge stage to do a many to many join, everything is working fine, just a little problem confused me few days. the null value in the first line of the merge stage output is transformed to 'Yes' for some unknown reason. This only happened on the first line. any one has met the same problem? is there any people having the experience to sort it out? thanks in advance.

Hi,

You are saying everything is ok,so what is your problem with null value,any way it is also passing na.

bye,
sudhakar

changming wrote:I use a merge stage to do a many to many join, everything is working fine, just a little problem confused me few days. the null value in the first line of the merge stage output is transformed to 'Yes' for some unknown reason. This only happened on the first line. any one has met the same problem? is there any people having the experience to sort it out? thanks in advance.

Hi,
Do you mean to say that a Null value has been changed to 'Yes' implicitly in merge is it?
It cannot be the case. Pls check if you have provided any default values/Null field value in the field properties.
Is there any other value comes with Null as output?

-Kumar