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

    Concatenate a case statement with fields

    edited Feb 13, 2020 9:17PM in Reporting and Analytics for HCM 3 comments

    Summary

    I want to concatenate a case statement with a field in OTBI. How would i do so?

    Content

     "Worker"."Person Type",
        CASE
            WHEN ( "Assignment Manager List Unsecured"."Manager Flag Code" = 'Y' ) THEN
                COUNT(DISTINCT "Assignment Manager (Unsecured)"."Person name1")
            ELSE
                null
        END 
    FROM
        "Workforce Management - Worker Assignment Real Time"
        

    I want to transform the above and concatenate the person type and count person name 1.

    example:

        CASE
            WHEN ( "Assignment Manager List Unsecured"."Manager Flag Code" = 'Y' ) THEN
             "Worker"."Person Type" || ',' || COUNT(DISTINCT "Assignment Manager (Unsecured)"."Person name1")
            ELSE
                null
        END 
    FROM
        "Workforce Management - Worker Assignment Real Time"

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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