Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC)

MOSC Banner

Import script giving extra columns in target data

edited Jul 26, 2016 10:19AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 13 commentsAnswered ✓

Hi All,

I converted Vb script to Jython but its giving extra C00 columns. I don't understand why its giving extra columns. Please correct the Jython script.

Function EaglePC2(strField, strRecord)

VB Code:

If strField = "" then

        PC = DW.Utilities.fparseString(StrRecord,15,11,";")

        For i = 1 to 10-Len(PC)

            PC="0" & PC

        Next

        EaglePC2 = "P" & PC

    Else

        For i = 1 to 10-Len(strField)

            strField="0" & strField

        Next

        EaglePC2 = "C"& strField

    End If

Converted Jython Code:

def EaglePC2(strfield,strrecord):

    if strrecord.split(';')[9]=='':

        return "P"+str(0)*(10-len(strrecord.split(';')[10]))+strrecord.split(';')[10]

    elif strrecord.split(';')[9].isdigit():

        return "C"+str(0)*(10-len(strrecord.split(';')[9]))+strrecord.split(';')[9]

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center