Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Row Data into Column Data

Question
36
Views
0
Comments
manyam16
manyam16 Rank 4 - Community Specialist

Summary

Row Data into Column Data

Content

Hello,

I have a requirement where I have to convert the row data into column data in the RTF Template.  I have put the sample XML and the PDF Output and the desired result I am looking for.

<?xml version="1.0" encoding="UTF-8"?>

<!--Generated by Oracle BI Publisher 11.1.1.9.0 -Dataengine, datamodel:__weblogic_Learn_BIP_EmpDept_xdm -->

<DATA_DS>

<G_1>

     <EMP_NAME>EMP1</EMP_NAME>

<DEP>ADMIN</DEP>

<CONT_NUM>123</CONT_NUM>

</G_1>

<G_1>

     <EMP_NAME>EMP1</EMP_NAME>

<DEP>ADMIN</DEP>

<CONT_NUM>456</CONT_NUM>

</G_1>

<G_1>

     <EMP_NAME>EMP1</EMP_NAME>

<DEP>ADMIN</DEP>

<CONT_NUM>789</CONT_NUM>

</G_1>

</DATA_DS>

Result:

image

I have used the grouping on Emp_Name and Dep in the above in the RTF Template as shown below:

image

I am looking for the result table look like this as below by concatenating the Cont_Num values.

Emp1          Admin               123,456,789.

Appreciate the help.

Thank you,