Consolidating Multiple Rows into Columns
SummaryWe are trying to get candiate Q&A questions to appear as columns vs. rows
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)" ).