Transforming Multiple Reports Using One Workspace
Each report that is being dropped into the workspace has four records of data which must remain grouped.
Our result looks like the following:
What I would like is to be able to drop multiple reports into the workspace and have it look like the following:
I have tried using transpose, but the result is one long row, any guidance on how to get the result I want would be greatly appreciated.
Find more posts tagged with
Altair EmployeeHow are you extracting the fields you want? It almost looks like you are appending the two tables. If the files are similar, and you are using report design, you should be able to put both files under the same table created from report design and get the result you are looking for.
The first column is coming from the detail line and the second column is being trapped using a group footer.
Altair EmployeeHave not used the newer versions of Monarch, but in the classic version I would have created a 4 row detail trap and identify the fields needed in your columnar output. If the reports are identical, then open them all at once and output them as one. I may be missing something, but a multiple line detail trap would work as I read the question.
How are you extracting the fields you want? It almost looks like you are appending the two tables. If the files are similar, and you are using report design, you should be able to put both files under the same table created from report design and get the result you are looking for.