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/
Michael Laurendi selected this answer as the correct answer
Comments Hi Subramanya,
Thank you for the prompt reply. I ran the rpeactual.com sample JS Arrays in RPE.
Is there a way that the script code can be viewed in the dta?
I am referring to the Iteration block that contains a Row which contains 4 Cells each with Text followed by "<script>".
I would like to view those 4 script codes. How do I do that in Document Studio?
This is not to be confused with the JavaScript Code elsewhere in the template because that is plainly visible.
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. |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.