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

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

Consolidating Multiple Rows into Columns

edited Dec 13, 2022 7:03AM in Taleo Enterprise 14 comments

Summary

We are trying to get candiate Q&A questions to appear as columns vs. rows

Content

I am trying to write a formula to convert the questions and answers from the candidate Q&A section so that they report as additional columns (1 column for each questions, with responses included in the data). Versus adding an additional row for each question/answer.  I am using the formula below, but it does not appear to be working.

 

EVALUATE_AGGR('MAX(CASE WHEN %1 = %2 THEN %3 END)' AS CHARACTER(200),"Candidate Q&A"."Question Description (BL)" ,'Candidate Response',"Candidate Q&A"."Answer (Choice) (BL)" ).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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