Skip to Content
0
Former Member
Feb 24, 2009 at 09:24 PM

Formula during transformation, with no values.

448 Views

Hi:

I have a transformation who has a formula for 2 KFs plus currency key, and the result goes to another KF with his currency key. The problem is that in the source DSO not always I have values for the source fields, and the DTP stops with an error. How can validate that I have all the required source filelds with "no empty values" before executing the formula in the transformation?. Any idea on how to write a "more intelligent" formula to avoid this error.?

Thanks in advance.