It's all about the answers!

Ask a question

RPE - how to convert multiple JRS rows to one row?


Michael Laurendi (1051845) | asked Mar 21 '18, 9:09 a.m.

 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


permanent link
Subramanya Prasad Pilar (4.6k16) | answered Mar 21 '18, 1:47 p.m.

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).

Michael Laurendi selected this answer as the correct answer

Comments
Michael Laurendi commented Mar 22 '18, 11:19 a.m.

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.

 


Subramanya Prasad Pilar commented Mar 22 '18, 12:30 p.m.

In the sample template (sampleJSArraysInRPE.dta), double click on the Text element (containing <script>), you will see the Script Expression used.


Michael Laurendi commented Apr 30 '18, 8:25 a.m.

 Thank you! I see the <script...> button now. I just needed to scroll the window down.

Your answer


Register or to post 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.