DSXchange

Hi Rohan, Were you able to identify the root cause for this issue? I am also facing a similar kind of issue where the surrogate key generator is generating keys which it had already created in the past and populated to the target table. One thing I noticed about the keys generated was that the min v...

Swathi,

Try something like this:
If Trim(in_dataset.Member_Relationship_Cd)="" Then 1 Else If Num(Trim(in_dataset.Member_Relationship_Cd)) then 1 else 0

Cheers,

K