Monarch Complete/Data Prep 15 footer/append limitations
Altair EmployeeI 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
Answers
-
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.
0 -
Altair Forum User said:
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.
0 -
Altair Forum User said:
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 just figured it out. Use MCR then Data Prep pivot functionality.
0
