How can I add multiple answers to multiple questions in OTBI?

Gabriel Leon

Hello, I hope I'm in the right place.

I need to create a SQL function:
I'm creating a report where I need to place an answer to a question in a column and replicate this same thing in other columns without giving me an error: Example:

In: Recruiting Real - Time:

"Job Application - Prescreening Responses"."Question Text" = 'What number do you prefer?'

and then indicate that the answer is in the column:

"Job Application - Prescreening Responses"."Question Response Long Description" = ('1', '2', '3')

If the candidate answered 2.

When generating the report the response is '2'.

In short, I need to create a function where I can ask the system to search for a question and the answer to that question, where only the answer to the question is displayed.

any suggestions? Thanks u.