Single Row Values Q

Master of Disaster

Hi all

I'm creating my first reports on R&A. And i am stuck WITH a basic thing.

I would like to have all the Preference's column result into a single row.

would appreciate your help, will save my team tons of time.

thanks

XML and sql code.docx

Gianni Ceresa

Text can't be aggregated (well, technically some aggregation functions works on varchar, but you will not get what you expect).

To concatenate multiple rows into a single one you should push down the job to the database using EVALUATE (or one of the variants of this function).

If you do use an Oracle Database you can then use LISTAGG for the job, for another database you should look for the function to use (if any).

Master of Disaster

OK thank you for the feedback my technical skills are no there yet to go further in the elaboration of this report. Iguess i will need to turn to an IT guy.

Do you know anybody who can assist me with this small project?

thanks

Gianni Ceresa

What is the exact name of the product (and its version)?

You should contact the people in charge of the platform in your company, there should be developers there knowing how to do the job.

Master of Disaster

OPERA R&A VersionTime run: 8/27/2023 3:35:56 PM  

ApplicationVersionInstalled DateUpdate DateRevision

ANALYTICS23.6.67/12/2023 3:19:27 PM7/12/2023 3:19:27 PMc00440f6

I am alone in the universe :|

   

Edit -Refresh -Print -Export - Add to Briefing Book

 -Copy