RPE - how to convert multiple JRS rows to one row?
CLM 605 / RPE 605
Hello,
I work with RPE getting data from a group in RTC and also a group using DNG. Sometimes the data from the reports contain multi-select values. When this happens, the rows repeat:
JRS Report being sent to RPE
ID-----------Multi-select Field A------------Field B <o:p> </o:p>
1234 Data1 Value1 <o:p> </o:p>
1234 Data2 Value1 <o:p> </o:p>
1234 Data3 Value1
When creating the RPE report, I want to create:
ID-----------Multi-select Field A------------Field B <o:p> </o:p>
1234 Data1,Data2,Data3 Value1
Anyone know how to accomplish this in RPE? More specifically, how to script this in the template in RPE? <o:p> </o:p>
Accepted answer
At first sight, this seems doable by storing the data (ID, Field A, Field B) in an ArrayList, sort and print the contents of the array. You may refer https://rpeactual.com/2014/08/12/arrays-in-rpe/
If this doesn't work, please share the .dta file (exported by JRS).
Comments
Hi Subramanya,
In the sample template (sampleJSArraysInRPE.dta), double click on the Text element (containing <script>), you will see the Script Expression used.
Thank you! I see the <script...> button now. I just needed to scroll the window down.