on 07-15-2009 2:16 PM
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
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]
Regards,
Frank
Edited by: Frank Lee on Jul 15, 2009 9:41 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.