You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • Conditional Source Expression with Concatenation as output

    in Financial Consolidation and Close 1 comment

    Summary:

    We are migrating HFM Import scripts to cloud. I am planning to leverage Conditional expression to achieve similar functionality but it is not working.

    Basically we plan to concatenate couple of columns depending on the condition. I am unable to concatenate two values . I am getting error.

    if (split(RECORD,"|",6) !="" and UD4 !=null) return "UD4 + split(RECORD,"|",6)"
    else return split(RECORD,"|",6)

    I tried Concat("UD4|split(RECORD,"|",6)","_") but both options did not work.

    I would appreciate if could anyone provide sample for concatenated two columns in source expression.


    Content (please ensure you mask any confidential information):


    Version (include the version you are using, if applicable):

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!