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
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Using Concatinate for select values

    edited Jun 27, 2018 6:49PM in Reporting and Analytics for HCM 2 comments

    Summary

    Using Concatinate for select values

    Content

    Hello!

    I am trying to concatenate a couple of fields, but there are certain "Job"."PER_JOBS_DFF_CNTRBTR_TYP_LFL_" values that I would like to not have concatenated.

     

    Here is what I have so far:

    CONCAT("Job"."PER_JOBS_DFF_CNTRBTR_TYP_LFL_",(RIGHT("Job"."Job Name",2)))

    Any help would be greatly appreciated.

    Jamie

     

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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