Skip to Content
avatar image
Former Member

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.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jul 15, 2009 at 01:40 PM


    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Frank,

      Thanks very much for your assistance, very grateful. I did use a routine as per the guide you sent and it did the job. Thanks again.