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

    can we use fetch multiple columns using single case statement

    in Reporting and Analytics for HCM 1 comment

    Hi Team,

    i am using the case statements as below to retrive the data for a single person but it is giving me the 4 rows for same person is there any way to group them all in a single row with different column name?

    ,CASE
    WHEN ques.question_text LIKE '%Any comments%'
    THEN nvl(ans_rat.long_text,ans_ent.answer)
    ELSE
    NULL
    END as Verbatim


    ,CASE
    WHEN ques.question_text LIKE '%How likely are you to recommend this program to a colleague?%'
    THEN nvl(ans_rat.long_text,ans_ent.answer)
    ELSE
    NULL
    END AS NPS

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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