Row Data into Column Data
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:
I have used the grouping on Emp_Name and Dep in the above in the RTF Template as shown below:
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,