1. Administrator's Guide
  2. Creating and Using Scripts
  3. Using Import Scripts
  4. Using Import Script Functions
  5. Using the Skip Function (Conditional Skip)

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

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.