The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.
I have a report that is really stumping me as to how to efficiently parse the data. My intention is grab the "Registrant Customer Identifier" as my detail trap and create footers and appends to capture the remaining lines of data. This puts everything in a neat table. Monarch Complete 15 including DP 15 is really fighting me on the number of footers/appends that I can set up, so I have split the process into 2 parts. Is there a better way to accomplish busting this report?
Janet Grimsley
Are you trying to put everything in the first column into 1 row...or both columns into 1 row? If so, either just capture every line as a detail (for both columns, use MCR), and then unpivot the data. You might need to add page number or something to break it out a little bit.
Chris, I am trying to put everything into one record with the data attached to the "Registrant Customer Identifier". I did try MCR, but that did not give me the result below. I will try that avenue again.
Chris, I just figured it out. Use MCR then Data Prep pivot functionality.
