Transformation fox formula
Please help am a BI newbee.
I am trying to load some data from PSA to DSO. I would like to specify in the transformations that if a particular field is blank that record should not pass through to DSO and error. The idea being that the errored records would be corrected and data would be loaded into the dso via an error DTP
I have gone through the available options in the foxformulas but could not identify any functions that i could use. Would it be better to use a routine? any pointers would be appreciated.
Yes you can write a routine like this:
if source_fields-YOURFIELD is initial. raise exception type CX_RSROUT_SKIP_RECORD. endif.
Then for every record with YOURFIELD blank will be skipped.
You can also have a look at this:
/message/7586412#7586412 [original link is broken]
Edited by: Frank Lee on Jul 15, 2009 9:41 PM