Using the Skip Function (Conditional Skip)
Problem: You want Oracle Hyperion Financial Data Quality Management, Enterprise Edition to skip all lines of the NewYork screen that contain an entity value that begins with 06
.
You must specify fdmSkip
as the return value from your function to skip a line in the file that is being processed in the import script. You specify fdmSkip
as the return argument from an import script by entering return fdmSkip
. fdmSkip
is only available for import scripts.
![The image shows the contents of the NewYork General Ledger screen. The contents are described in the text preceding the image The image shows the contents of the NewYork General Ledger screen. The contents are described in the text preceding the image](img/ny_csv_gl.jpg)
Solution: In the Import Scripts screen, you assign the following script to the Expression field of the Entity row. The script parses the entity column and uses a local variable that is discarded after the script executes:
def NY_Skip06Center(strField, strrecord):
if strfield.count("-") > 0:
seglist = split(strField, "-")
strEntity = seglist[0]
if strEntity[:2] == "06":
return fdmSkip
else:
return strEntity
Result: No line that contains entity values that begin with 06 is imported.