Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Transformation fox formula

Hi Gurus,

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.



Former Member
Former Member replied


Yes you can write a routine like this:

if source_fields-YOURFIELD is initial.
  raise exception type CX_RSROUT_SKIP_RECORD.

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question