we have questin text and answer report but all questions are coming in columns

Question

Summary:

Hi ,

we have questin text and answer report but all questions and answers  are coming in columns.

so we get multiple records  for each employee i mean 7 questions we get seven records how to over come this issue?

PFA.

SQL --issued.txt

report format.xlsx

Thanks,

Ajay

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

vgudaHCM · Answer

Yes, using Pivot table would help in getting all responses in a single row instead of getting one row for each question response (therefore multiple rows for each candidate).

I have a different issue. Anyone has a multiple choice/selection question and able to get all answers (more than 1 answer to the question like some one who selected multiple languages they could speak) in the output? My report only shows one response in the output and its a random response (not alphabetical).

Bhaskar Konar · Answer

Hi @AjayKumar Maddipati,

It is possible to do that row wise. You have to use the Pivot table. I was trying with your sql but it seems you have few DFFs which are not present here, as a result I'm not able to modify your report.

If you have a simpler version without any DFFs then please attach the report xml so that I can try.

Here is the output of my report where you can see the all answers in a single row.

Hope this help.

Cheers,

Venkat Koduvayur-Oracle · Answer

Since your requirement is to pivot the data (rows to columns), then you could create a pivot table view while creating the report instead of table view. I suppose that will solve your issue

Regards

Venkat