cancel
Showing results for 
Search instead for 
Did you mean: 

Transformation fox formula

Former Member
0 Kudos

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.

thanks

syed

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

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]

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/50fda171-e36e-2910-9290-e3dab26c...

Regards,

Frank

Edited by: Frank Lee on Jul 15, 2009 9:41 PM

Former Member
0 Kudos

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.

Answers (0)